Scenario Overview

In this business scenario it was very important for the people paying Invoices to know the current week number & what the UTC date and time was before paying an Invoice.

N52 Formula Manager Solution

The Formula Manager solution works like this,

  • A formula is created which executes when the Invoice record is opened
  • It calculates the current week number from the current date time & the UTC datetime
  • It displays the information as a form notification

N52 Formula Manager Steps

  • Create a new formula of type 'ClientSide - Perform Action'
  • Set the Source Entity to 'Invoice'
  • Set the Source Property to 'OnLoad'
  • Copy & paste the formula below into the formula description field & click save
  • Click 'N52 Commands' & then choose 'Publish Formula'
  • You are ready to test


SetFormNotification(StringFormat('Current Week Number: {0} UTC Datetime: {1}',
  GetWeek(LocalDateTime()), UtcDateTime() ) , 'INFO', 'msg1')


Did you know?

North52 provides Automated Testing for Dynamics 365

TestShield® is a unique solution that helps you automatically test your End to End Dynamics 365/CRM and Power Automate processes.  It is built on the proven and robust North52 Business Process Activities rules engine and offers the ability to repetitively test and report on your key business processes.

TestShield's key features:

  • Fully integrated with Dynamics 365
  • Easy to use by BA's, Testers, and Developers
  • Advanced test data generation and management
  • Codeless advanced testing reduces test creation time
  • Test and validate across all layers with a single test

Learn more about TestShield