Weird time conversion in the UI

How To
1

Anyone have any ideas why this timecode is getting converted like this
image

My Formula for this is:
{{setHour(setMinute(addDays(now; 182); 1); 0)}}

My plan originally was to check if date in the data store = now +182 days and I was using setHour, setMinute and setSecond however this still leaves the milliseconds on the timecode that can’t be set (as far as I know) so my work around was this:
image
but this causes the weird timecode issue above

2

You have to format the date according to the date in your dataset
{{formatDate(setHour(setMinute(addDays(now; 182); 1); 0); 'your dataset date format ')}}

Here you can know more about formatDate function: here

3 Likes