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
Dual Super User

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
Dual Super User

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.

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
Power Platform Conf 2022 768x460.jpg

Join us for Microsoft Power Platform Conference

The first Microsoft-sponsored Power Platform Conference is coming in September. 100+ speakers, 150+ sessions, and what's new and next for Power Platform.

PA Virtual Workshop Carousel 768x460.png

Register for a Free Workshop

This training provides practical hands-on experience in creating Power Apps solutions in a full-day of instructor-led App creation workshop.

PA.JPG

New Release Planning Portal (Preview)

Check out our new release planning portal, an interactive way to plan and prepare for upcoming features in Power Platform.

Top Solution Authors
Top Kudoed Authors
Users online (3,479)