Unanswered

CONVERT DATE ISO 8601

(0) Share

Report

Posted on by Gorilla_8

Hey guys, I need to filter a gallery by date, but on the collection, the date comes like this:

1582097400000

There is a possibility to convert and make a filter my gallery by date? And I need to make a default filter date + 7 days forward.

The name of the column: DatadeIníciodaTarefa

Thanks for the help guys!

Categories:

Building Power Apps

All responses (15)

Answers (0)

Sort by

Pstork1 69,661 Most Valuable Professional on at

Like
a
(1)

Report
Copy link

Link copied!
I believe what you have is the number expressed in Ticks. Ticks in this case being the number of seconds after midnight on 01/01/1970. So you can use the following formula to convert a regular date field to a similar number and use that for sorting

DateDiff(DateTimeValue("01/01/1970 00:00:00"), DateFieldToConvert, Seconds)

Or you can convert the Ticks back to a date using this formula

DateAdd(DateTimeValue("01/01/1970 00:00:00"),NumberOfTicks,Seconds)
mdevaney 29,993 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!
@Gorilla_8

Please provide instructions for how to convert this number into a date.

1582097400000

Also let the forum know what date this number translates to?

---
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."
mdevaney 29,993 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

Well... at least @Pstork1 understands what that crazy number means 😁
Gorilla_8 on at

Like
a
(0)

Report
Copy link

Link copied!

@mdevaney I don't have a clue about how to convert this number to a date 😞

I need help with this...
mdevaney 29,993 Moderator on at

Like
a
(0)

Report
Copy link

Link copied!

@Gorilla_8

...did you try the suggestion of @Pstork1?
Gorilla_8 on at

Like
a
(0)

Report
Copy link

Link copied!

@Pstork1

Where?
Pstork1 69,661 Most Valuable Professional on at

Like
a
(0)

Report
Copy link

Link copied!

First, since the number is measured in Ticks, the number of seconds after midnight on 01/01/1970. you can just sort based on that numeric field. Larger numbers are later and smaller numbers are earlier.

For the range calculation. Add or subtract the number of seconds in the time period you want to use. 7 days would be 7 * 24 hours * 60 minutes * 60 seconds. That comes to 604,800 seconds.

to convert back into a date use the formula I provided in my previous reply.
Gorilla_8 on at

Like
a
(0)

Report
Copy link

Link copied!

@Pstork1 Thanks for the reply!

But unfortunately, I can't find the reply post you are mentioning...

Sorry about that 😞
Pstork1 69,661 Most Valuable Professional on at

Like
a
(2)

Report
Copy link

Link copied!
It was the first reply on this post.

I believe what you have is the number expressed in Ticks. Ticks in this case being the number of seconds after midnight on 01/01/1970. So you can use the following formula to convert a regular date field to a similar number and use that for sorting

DateDiff(DateTimeValue("01/01/1970 00:00:00"), DateFieldToConvert, Seconds)

Or you can convert the Ticks back to a date using this formula

DateAdd(DateTimeValue("01/01/1970 00:00:00"),NumberOfTicks,Seconds)
Gorilla_8 on at

Like
a
(0)

Report
Copy link

Link copied!
Thanks for the reply @Pstork1 !

Here some my code:

toggle_porcentagem.Value = true; Filter( AddColumns( collTaskListForGallery; "DateColumn"; DateAdd( DateTimeValue("1970-01-01 00:00:00"); Value( Mid( DatadeIníciodaTarefa; 7; 13 ) ); Milliseconds ) ); If( drpFilter.Selected.Value = "Data início"; Text( DateColumn; DateTimeFormat.ShortDate ) = Text( DatePicker1.SelectedDate; DateTimeFormat.ShortDate ) ) )