Default date and time

Question

Hi Team, 
 I have a requirement where the default date and time field should display the nearest rounded time. For example: 
 
 If the current time is 3:54 PM , the default time should be set to 4:00 PM . 
 If the current time is 4:01 PM , the default time should be set to 4:30 PM . 
 
 Is there any simple way to acheive this

Mathieu Drouin · Accepted Answer

datetime(
 year(now()),
 month(now()),
 day(now()),
 if(
 minute(now()) <= 30,
 hour(now()),
 hour(now()) + 1
 ),
 if(minute(now()) <= 30, 30, 0)
 )

Vyshnavi Naripeddi · Answer

Hi divyam892747 , 
 you could try something like this a!localVariables(
 local!min: minute(now()),
 a!addDateTime(
 startDateTime: now(),
 years: 0,
 months: 0,
 days: 0,
 hours: 0,
 minutes: if(
 and(local!min => 30, local!min < 60),
 60 - local!min,
 30 - local!min
 )
 )
)

Default date and time

Top Replies