You’re offline. This is a read only version of the page.
Hi,
I have trouble manipulating datetime, i get this format: (dd-MM-YYYY hh:mm:ss)
Start time: 01-02-2024 06:08:13
End time: 01-02-2024 06:12:42
I then want to format it into this (Rounded up or down to the NEAREST 30 minutes)
Start time rounded: 01-02-2024 06:00:00
End time rounded: 01-02-2024 06:00:00
I would also like to just get the time:
Time only: 06:00:00
Hi,
Thanks a lot for the reply!
I've been away, so thats why i'm replying so late. I am wondering how I would go about doing it when my datetime comes from Sharepoint when a new element is made.
I have the "@{triggerBody()?['Title']}" do i just replace utcNow() with the @triggerbody?
This may not be the most glamourous or efficient way to do this, but this works:
On the No side of the condition:
Initialize three variables:
Set the default value of Hour to:
Share
Report
All responses (
Answers (
formatDateTime(utcNow(),'HH')Set the default value of Minute to:
int(formatDateTime(utcNow(),'mm'))
Then the logic checks:
You'll need to adjust the hours for your time zone.
#1
WarrenBelz
146,645
Most Valuable Professional
#2
RandyHayes
76,287
Super User 2024 Season 1
#3
Pstork1
65,997
Most Valuable Professional
