Forum Discussion
Solved
Add custom date column containing the current date
Hi, I'm trying to create a custom column that adds the current date. The current date is the Date column with the highest number. In my example for Project1 the current date can be found in colum...
Oh, I misunderstood you. Then the custom column would look like:
[Date3] ?? [Date2] ?? [Date1]
Your custom column would look like:
List.Max({[Date1], [Date2], [Date3]})
Thank you for your reply!
Unfortunately for Project1 the column [Date3] has an earlier date than [Date2] and it should pick the date in the column with the highest number, so List.Max() does not work here.
I guess the List.Max should work.
Can you please check the date format of all the date column used here. Is it dd/mm/yyyy or mm/dd/yyyy?