How do I extract only the time from a Date and Time data?

0
I have a member called PlannedTime which is of type Date and Time. I need to make sure the format I set to it is full hour (e.g.18:00 not 18:02). How do I do that?   Thank you
asked
2 answers
3

Hi Andriana,

Lets Assume your datetime format will be ‘01/08/2023 15:10’
Then kindly use the below operation to get date as ‘01/08/2023 15:00’

parseDateTime(formatDateTime($Entity/Date,'dd/MM/yyyy HH:00'),'dd/MM/yyyy HH:mm')

answered
0

Hi Adriana,

 

it would look something like this:

parseDateTime(formatDateTime($yourDate,'yyyyMMddhh00'),'yyyyMMddhhmm')

 

answered