Google Sheets Timestamp

Questions
1

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

2

Could you please share more details? The formula which you are passing in google sheet module for Date…

3

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!

image
image1920×1341 121 KB

image
image2388×1668 277 KB

4

Go for now function with proper formatting like formatDate function

MSquare Automation Solutions

5

@cre8iongroup

The timestamp is the UNIX timestamp… the number of seconds from Jan 1, 1970. It can be converted to a date.

But, as @Jouher suggested, the simpler way is to just use “now” and “formatDate”.
Something like:

formatDate(now; YYYY-MM-DD)
or
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

6

@JimTheMondayMan and @Jouher
Thank you for your help with this. The formatted now will work a lot better. In my head it was just easy to drop in the timestamp but I didn’t realize what format it was in.

It was helpful knowing that the now provides more precision.