Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to Solution.
Hello! Please try this:
if Date.IsInCurrentMonth([End Date]) then Date.From(DateTime.LocalNow()) else [End Date]
Hello! Please try this:
if Date.IsInCurrentMonth([End Date]) then Date.From(DateTime.LocalNow()) else [End Date]
You are close:
if Date.IsInCurrentMonth([End Date])=true then DateTime.LocalNow() else [End Date]