Adding a timestamp dd/mm/yyy

[Carlos_Adell]

Hey guys! I am trying to add a timestamp when a new contact has accepted my LinkedIn connection.

What I am using is what you can see on the screenshot below, but the value that is being added to the google sheets is what you can see on the other screenshot.

Is there a way to format the timestamp so it shows dd/mm/yyyy?

[Runcorn]

You need to format the date using formatDate and since timestamp is an integer you need to first parse it to date object and then do the formatting like,

{{formatDate(parseDate(timestamp; "X"); "DD/MM/YYYY")}}

Or, you can use now instead,

{{formatDate(now; "DD/MM/YYYY")}}

[Carlos_Adell]

Thank you so much @Runcorn appreciate your quick response. I have copied the exact same values you gave me {{formatDate(now; “DD/MM/YYYY”)}} into the workflow

Since I seem to be running into a lot of these little things, where is the best way for me to go to learn about them?

[Runcorn]

There was a post dedicated to learning this week,

Learning Make Automations

Heya @Eric_Automations I’m sure folks will jump in with more recommendations in no time but here are my two cents. Worth checking out Alex pointing out a couple of tutorials (you may have already gone over them, though: Make help docs have lots of tutorials A bunch of video recommendations: Does Make Have Step-by-Step Video Tutorials? Training sessions A whole lotta wisdom has already been shared in the community. A coupl…

Maybe it jas some useful stuffs that you are looking for.

[Carlos_Adell]

Hey @Runcorn after following your advice, and running a few tests, here is the info as it comes into my spreadsheet, also see the values in Make, what am I doing wrong?

`

[Runcorn]

You should use DD/MM/YYYY without any quotes and / operator it is just a plain text.

formatDate(date;DD/MM/YYYY)

[Carlos_Adell]

@Runcorn

{{formatDate(now; “DD/MM/YYYY”)}}

Thank you!! Changed it back, I am not sure why when I copied the text from here, it got formatted that way.