I have a Date Time variable in a SP List called 'Occ Out Date' and I'm creating the variable MaxDate as the Max value. All OK.
This by default creates a number which I assume is milliseconds.
UpdateContext(
{
MaxDate: Max(
ThisAttendeeHotels,
'Occ Out Date'
)
}
);
I can render this on a page in a label by doing...
" Max Check Out=" & Text(MaxDate,"[$-en-US]mm/dd/yyyy")
When I view the variable I see "it's a number" variable and the value is 16020273600000 which when converted in the label displays what I'd expect.
All good so far...
But now I want to see the date difference between the MaxDate variable and a true date/time variable.
I'm not comparing the time only the date.
In my global variables I have a DateTime variable called DepartDate that reads 5/6/2021 5:21 PM.
There are 2 questions...
1) How do I compare the date value of the MaxDate and the DepartDate's?
2) Wouldn't it make more sense to create the MaxDate as a DateTime variable in the very beginning - if so, what would I do to create that as such in the very beginning?
