I have a scenario that I’m adding a new row to Google. I would like to add a timestamp, so I added the Timestamp item variable from Make. But when it’s out putting a number that is not translating in Google Sheets. I tried to switch it to a date number format but it stays the same. This is an example number 1651529941
Could you please share more details? The formula which you are passing in google sheet module for Date…
I’m using the timestamp from the make functions list. I’ve included screenshots of what it looks like hopefully that gives some clarity. Thank you for helping!
Go for now function with proper formatting like formatDate function
The timestamp is the UNIX timestamp… the number of seconds from Jan 1, 1970. It can be converted to a date.
But, as @Jouher_Automator suggested, the simpler way is to just use “now” and “formatDate”.
formatDate(now; YYYY-MM-DD HH:mm:ss.SSS)
And, if you are want more precision, “now” returns date/time in thousandths of a second. (See second example above.)
Jim - The Monday Man (YouTube Channel)
Watch Our Latest Video: The monday ITEM ID column - What most people don’t know.
Contact me directly here: Contact – The Monday Man