How do I add a date in a specific format?

Question

I've looked and tried multiple things but simply can not figure it out so here I am.

I want to Tweet the time and date exactly like this:

9:00 Monday 23rd January 2023

Accompanied by an image. I have the image all sorted (the part I thought would be the most difficult but was very simple)

Currently I am using the below as my Message in the Tweet section of my Zap:

Which is ALMOST right, except it is not including the 2 digits of the Minutes and is not including the date quite how I’d like.

Is there a way to simply input the format like you would in BB code or similar? I simply can not work out how the Formatter integrates into the next section of the Zap.

Thanks for any assistance you can give

icon

Best answer by LdnWx 23 January 2023, 12:16

View original

LdnWx · Accepted Answer

For the input you’d select the field that contains the date you’re looking to convert. Then in the To Format field you’d select the Custom value option and then type in the format you want. Which would be H:mm dddd Do MMMM YYYY

For example:

Then should then output the date in the format you’re after (9:00 Monday 23rd January 2023).

I tried this, but how do I select that to be entered into my Tweet?

That is where I got lost.

SamB · Answer

Welcome to the Community, @LdnWx!Hmm, you could use a Formatter (Date / Time > Format) action to convert the date into the desiredcustom date format.For the input you’d select the field that contains the date you’re looking to convert. Then in the To Format field you’d select the Custom value option and then type in the format you want. Which would beH:mm dddd Do MMMM YYYYFor example:Then should then output the datein the format you’re after (9:00 Monday 23rd January 2023). You might also want to check out this guide for more information:Modify date and time formats in ZapsHope the above info is helpful. Please do let us know how you get on with this!🙂

Sign up

Use your Zapier credentials

Log in to the Community

Use your Zapier credentials

Scanning file for viruses.

This file cannot be downloaded