Forum Discussion
Syndicate_Admin
2 years agoAdministrator
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...
- 2 years ago
Hello! Please try this:
if Date.IsInCurrentMonth([End Date]) then Date.From(DateTime.LocalNow()) else [End Date]
jennratten
2 years agoSuper User
Hello! Please try this:
if Date.IsInCurrentMonth([End Date]) then Date.From(DateTime.LocalNow()) else [End Date]
- jennratten2 years agoSuper User
Syndicate_Admin Will the solution be reviewed/accepted?