cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
samuelJ
Responsive Resident
Responsive Resident

How Are dates stored in Collections

Hi How are dates stored in collections?

I have stored a date in a collection and looking at the collection i see this long sting.  What does it represent?
collectionDate.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
mdevaney
Super User
Super User

@samuelJ 
That date looks like it is being stored in UNIX time.  For example, if you put this code in the Text property of a label

Text(1588921200000,"[$-en-US]mmmm d, yyyy")

 

The result will be

May 8, 2020

 

 

I only see dates stored in collections like this when the datasource was originally SQL

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

View solution in original post

1 REPLY 1
mdevaney
Super User
Super User

@samuelJ 
That date looks like it is being stored in UNIX time.  For example, if you put this code in the Text property of a label

Text(1588921200000,"[$-en-US]mmmm d, yyyy")

 

The result will be

May 8, 2020

 

 

I only see dates stored in collections like this when the datasource was originally SQL

 

---
Please click "Accept as Solution" if my post answered your question so that others may find it more quickly. If you found this post helpful consider giving it a "Thumbs Up."

Helpful resources

Announcements
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.

PWREduCon768x460.png

Join us at PWR EduCon - A Power Platform Conference

Learn from the top Power BI, Power Apps, Power Automate & Power Virtual Agents experts!

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