TimeZoneIndependentDateTime - Required.When used in a behavior formula, volatile functions will be evaluated each time the behavior formula is evaluated. For example, if we change our example to involve a slider control with Label1.Text = DateAdd( Now(), Slider1.Value, Minutes ) then the current time is retrieved each time the Slider control's value changes and the label's text property is reevaluated. The function will be reevaluated if it is part of a formula in which something else has changed. Only closing and reopening the app will result in a new value. If nothing else changes in the formula then it will have the same value throughout the execution of your app.įor example, a label control with Label1.Text = Now() will not change while your app is active. When used in a data flow formula, a volatile function will only return a different value if the formula in which it appears is reevaluated. These functions return a different value for each evaluation. Now, Today, UTCNow, and UTCToday are volatile functions. See Date, Time, and DateTime in the data types documentation and working with dates and times for more information.

More information: Work with formula table columns in Dataverse for Teams Now, Today, and IsToday are not available in Dataverse for Teams formula columns as evaluations are done without the knowledge of the current user's local time zone.UTCNow, UTCToday, and IsUTCToday are only available in Microsoft Dataverse for Teams formula columns, and only for time-independent fields and values.

Date of today