Parsed Dates Still Passing to Google Sheets as Timestamps

How To
,
1

I have an odd behavior where Make seems to have parsed the date correctly on this Update Rows module, but Google Sheets is still getting the unparsed Unix timestamp:

image
image1533×288 49.8 KB

The syntax is: {{parseDate(35.end_time; "YYYY-MM-DD HH:mm")}}
Any idea what could be causing this? Something on Google’s end? Never seen anything like it before. Many thanks in advance!

1 Like
2

Update: formatDate() instead of parseDate() solves the problem.

3 Likes
3

Hi @Robert_McKay :wave:,
Congratulations on solving this puzzle on your own! :jigsaw:

Thanks a lot for remembering to share your insights with us and marking them as a solution. This way our community stays tidy, neat, and easy to look for solutions. :broom:

Keep up the great work!

1 Like