web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps RoundDown UTC time

Power Apps

Unanswered

RoundDown UTC time

(0) Share

Report

Report

Posted on by PGTips

35

How would I round down the current time in UTC format to the nearest hour or 30 minute interval?

E.g:

Time now = 02/14/2020, 14:28

So I want to set a variable to = 02/14/2020, 14:00 (rounding down to the nearest hour or 30 minute interval)

Categories:

Building Power Apps

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (1)

Verified answer

mdevaney 29,989 Moderator on at

Like (0)

Report
@PGTips

Please try this code:

Set(myDateVariable, Today() + Time(Hour(Now(),RoundDown(Minute(Now())/30,0),0) )

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

Was this reply helpful? Yes No
GarethPrisk 2,828 on at

Like (0)

Report
DateAdd( Now(), (Minute(Now()) * - 1) + If( Minute(Now()) >= 30, 30, 0 ), Minutes )

The previous response works as well. Thanks @mdevaney

EDIT: Corrected mine to account for the 30 minute interval requirement.

Was this reply helpful? Yes No
PGTips 35 on at

Like (0)

Report

Amazing, thanks! And then finally, how would I convert to this format: "2020-02-14T09:00:00"

Was this reply helpful? Yes No
mdevaney 29,989 Moderator on at

Like (0)

Report

@PGTips
Like this. Try it out in the Text property of a label.

Text(myDateVariable,”yyyy-mm-dd”)&”T”&Text(myDateVariable,”hh:mm:ss”)

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

Was this reply helpful? Yes No

Join the conversation