You’re offline. This is a read only version of the page.
Announcements
3
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.
Share
Report
All responses (
Answers (
