cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
sasrsc
Resolver II
Resolver II

Convert milliseconds into a date and store as a date variable

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?





1 ACCEPTED SOLUTION

Accepted Solutions
Pstork1
Dual Super User III
Dual Super User III

To convert MaxDate into a DateTime value use the DateTimeValue() function.  Then you can get the difference in days using the following.

DateDiff(DepartDate,DateTimeValue(Text(MaxDate,"[$-en-US]mm/dd/yyyy") ),Days)

Its an easy enough conversion and I don't see a reason to change what you are doing if the values display correctly in the label.

 



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

2 REPLIES 2
Pstork1
Dual Super User III
Dual Super User III

To convert MaxDate into a DateTime value use the DateTimeValue() function.  Then you can get the difference in days using the following.

DateDiff(DepartDate,DateTimeValue(Text(MaxDate,"[$-en-US]mm/dd/yyyy") ),Days)

Its an easy enough conversion and I don't see a reason to change what you are doing if the values display correctly in the label.

 



-------------------------------------------------------------------------
If I have answered your question, please mark your post as Solved.
If you like my response, please give it a Thumbs Up.

View solution in original post

Thanks PStork...

In the end I took your advice and kept the variable as a number...
I'm actually displaying an icon as a warning when they don't match...with the visible property reflecting...(in case this helps others)
DepartDate is a date/time variable
MaxDate is a number (reflected in milliseconds)



If(DateDiff(DepartDate,DateTimeValue(Text(MaxDate,"[$-en-US]mm/dd/yyyy") ),Days) <> 0, true,false)




Helpful resources

Announcements
PA_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Carousel 2021 Release Wave 2 Plan 768x460.jpg

2021 Release Wave 2 Plan

Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.

Top Solution Authors
Top Kudoed Authors
Users online (2,403)