jeudi 22 décembre 2016

Power query - Calculated column to check date

I have a column "MYDATE" with dates (dd/mm/yyyy) and I need to create a calculated column that checks if the date is today's date.

I have tried '=if [MYDATE]=DateTime.LocalNow() then "Yes" else ""' this butit did not work because of the different format.

Any suggestion?

Aucun commentaire:

Enregistrer un commentaire