Forum Discussion
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.
if Date.IsInCurrentMonth([End Date])=true then DateTime.LocalNow else [End Date]
| End Date | Required date |
12/01/2023 | 12/22/2023 |
11/01/2023 | 11/01/2023 |
| 10/01/2023 | 10/01/2023 |
When I click on Function it goes to invoked function and shows current time and date. Please help me with this.
Hello! Please try this:
if Date.IsInCurrentMonth([End Date]) then Date.From(DateTime.LocalNow()) else [End Date]
4 Replies
Hello! Please try this:
if Date.IsInCurrentMonth([End Date]) then Date.From(DateTime.LocalNow()) else [End Date]
Syndicate_Admin Will the solution be reviewed/accepted?
You are close:
if Date.IsInCurrentMonth([End Date])=true then DateTime.LocalNow() else [End Date]- You are close if Date.IsInCurrentMonth([End Date])=true then DateTime.LocalNow() else [End Date]
