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
stampcoin
123
#2
David_MA
104
Super User 2025 Season 1
#3
Michael E. Gernaey
90
Super User 2025 Season 1
