Configure the format of your date
When you open the Template configuration sidebar, you will notice different date and time formatting options in the 'Date' marker:
Form Publisher lets you choose between different formats:
- dd/MM/yyyy HH:mm:ss
- MM/dd/yyyy hh:mm:ss
- yyyy/MM/dd HH:mm:ss
If you want to display the time with AM/PM settings instead of military time, write 'hh' in lowercase, and add an 'a' in the format settings: 'MM/dd/yyyy hh:mm a'
→ 01/31/2015 6:30 PM
Patterns you can reuse to change your date format
Date and time formats have to follow very specific and precise patterns, formed with letters in uppercase from A to Z, and lowercase from a to z.
Here is a table displaying the letters used to write date and time using specific formats:
In general, if there are 4 (or more) pattern letters, text formatting will be applied. If it’s less than 4 letters, the text will be shortened or be recognized as a number:
EEEE → Tuesday
EEE → Tue
Months
Type each pattern letter at least 3 times or more to display them in text format:
MMMM → September
MMM → Sep
Use as many letters as there are digits to display months in number:
MM → 09
Years
Use 2 pattern letters to truncate the year to 2 digits:
YY → 15
Use more than 3 pattern letters to display the year completely, as a number:
YYYY → 2015
Hours and Minutes
By default, hours are displayed between 0 and 23 and minutes between 00 and 59.
Use 2 pattern letters to display hours and minutes with 2 digits:
HH:mm → 22:23
To display hours from 1 to 12, use 'hh':
hh:mm → 10:23
Add 'a' after writing patterns to display am / pm:
HH:mm a → 10:23 PM
Read the complete documentation about date and time settings.
Comments
17 comments
Any way to format the output date captured using the date picker in a form? Currently it comes as yyyy-mm-dd but I would love for 'MMM d, YYYY'
Hi,
@Craig, you can do that by editing the configuration of the question in the Template sidebar just as explain in this article.
*facepalm*
My apologies, when I originally read this I thought it applied only to the timestamp.
What about changing time zone. Default is GMT but need to change to PST
@Yrosales,
Hey there, we can change the time zone for you. Just drop us a message here:
support@form-publisher.com
That will be great! My Time Zone is PST (Pacific Standard Time) California
i cant install add on. pls help me
Hi @Tchach,
This issue has been fixed, you can now install Form Publisher without any problem.
If you have any other issues, please feel free to reach us here.
Regards
Hello,
I used << Today >> to generate today's date, but I wanted to use a script to generate the date one year from today as well. Is this possible?
Hi Bader Jaafar,
Unfortunately, it is not possible yet.
If you have any other issues, please feel free to reach us here.
Richard
how do i make text fields in a template output uppercase letters ?
Hi Bonifacio Insurance Broker Corp.
Form Publisher cannot change this yet.
Best regards,
FP Team
I need my timezone fixed its coming up GMT for me still and my queue line says 2555 in progress. Anyway to get this fixed sooner. my timezone on form submissions should be eastern not GMT
Is it possible to have date as 1st, 2nd, 3rd, 4th,...
Hi,
I have a problem that the order of the date format is coming out wrong on my documents.
In form publisher (within google forms), the date format is set to MM/dd/yyyy. But when my colleague uses the google form, the generated google doc shows the date format as yyyy/mm/dd.
What do I need to do to solve this?
Christopher
Hi,
I use the <<Workflow date>> tag. IS it possible to change the format of this date? Thanks,
Hi Christopher,
Is the problem still there? You should now be able to edit date format for all date markers (timestamp and workflow date). Please reach out to our support here: https://support.form-publisher.com/hc/en-us/requests/new
Thanks
Rémi - Form Publisher Support team
Please sign in to leave a comment.