You’re offline. This is a read only version of the page.
Announcements
21
Hi i am trying to insert a default datetime of 0000-00-00 00:00:00 if the field is empty but it kept giving me an error. Does power automate allow 0000-00-00 as datetime?
formatDateTime('0000-00-00 00:00:00', 'yyyy-MM-dd HH:mm:ss')
Hi @jtanwm ,
point is that you try to format the year 0000, month 00, day 00 to a valid date. But the problem is that there is no day 0 in the calendar, also not for month or year (obviously there was the year 0000 but you know what I mean ;)).
Therefore I would go for that
formatDateTime('0001-01-01 00:00:00', 'yyyy-MM-dd hh:mm tt')
formatDateTime(utcNow(), 'yyyy-MM-dd hh:mm tt')
Share
Report
All responses (
Answers (
