Forum Discussion
Syntax near Duration.Days
My computer works for ([Endday] is a column of my table):
Duration.Days(DateTime.LocalNow()-[Endday])
and Duration.Days(#date(2023,11,11)-#date(2023,10,31))
It didn't work for
Duration.Days(DateTime.LocalNow()-#date(2023,10,31)),
Duration.Days([Endday]-#date(2023,10,31))
I can't understand. Please help.
Mixing DateTime and Date?
What do you mean?
I tried a few times. The two dates should be date or datetime. Two failed case is because of they are not the same.
