Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Icon for Administrator rankAdministrator
2 years ago
Solved

DateTime.LocalNow - returns "Function"

Hi,    Below is the data for which I want to get today's date, if it's in current month. I wrote a formula, which is returning as "Function" in cell value. How to get Today's date in the cells.  i...
  • jennratten's avatar
    jennratten
    2 years ago

    Hello! Please try this:

    if Date.IsInCurrentMonth([End Date]) then Date.From(DateTime.LocalNow()) else [End Date]

jennratten's avatar
jennratten
Icon for Super User rankSuper User
2 years ago

Hello! Please try this:

if Date.IsInCurrentMonth([End Date]) then Date.From(DateTime.LocalNow()) else [End Date]