DateTime.LocalNow - returns "Function"

[Syndicate_Admin]

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. 

[jennratten · Accepted solution]

Hello! Please try this:

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

[jennratten]

@Syndicate_Admin Will the solution be reviewed/accepted?

[Syndicate_Admin]

You are close if Date.IsInCurrentMonth([End Date])=true then DateTime.LocalNow() else [End Date]

[ronrsnfld]

You are close:

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