I'm having an issue when trying to create a custom column that needs to compare an action date with todays date. The cause of the issue has been narrowed down to the below, and I'm not sure why what I've pasted doesn't work? if [Action Date] < DateTime.LocalNow() then "something" else "other"

Hi Anonymous, I guess the data type of [Action Date] is date, while DateTime.LocalNow() returns datetime, which leads to unmatched error. Please modify your code as below: =if [Date] < DateTime.Date(DateTime.LocalNow()) then "something" else "other" Best regards, Yuliana Gu

Trouble comparing dates with todays date | Microsoft Fabric Community

Forum Discussion

Related content

Data Ingestion Troubles

comparation today

Today compared to same day last year

Having trouble refreshing my data.

Trouble scraping SharePoint Version History