Add a Submission Date on Email Notification

Last Update: March 14, 2016

You may need to add submission dates in email notifier or in your Thank You message. In order to accomplish this, use {DATE} tag like the following.


If you use {DATE} without a parameter in your template it will be automatically replaced with a standard date time string as shown in the first row of the table below.

If you want to format the date string you can do so by adding a parameter to the tag: {DATE:arg}. We have some predefined parameters as shown below but if you need more customized dates you can do it with standard PHP date formatting


TagOutput
{DATE}2011-02-07 05:17:05
{DATE:Date-US}Feb 7, 2011
{DATE:Date-EU}7 Feb, 2011
{DATE:Time-US}5:17:05 AM
{DATE:Time-EU}5:17:05
{DATE:Full-US}Feb 7, 2011 at 5:17:05 AM
{DATE:Full-EU}7 Feb, 2011 at 5:17:05
{DATE:l, jS \of F Y \a\t g:i A}Monday, 7th of February 2011 at 5:17 AM


If you have useful formatting examples which other users can benefit please share them in the comments below.


20 Comments...


   
abajan (February 07, 2011 at 10:25 AM)

I'm quite pleased with the way it works. I just tested it a sentence in an autoresponse in the following way: On {DATE} at around {DATE:Time-EU}, someone etc...

That generated the following output: On Feb 7, 2011 at around 10:56:05, someone etc...

However, it would be nice if there was a way to adjust the hours (by appending +1 for instance) to the Time variable because I actually wanted 11:56:05 AM (Barbados time).

Also, what will happen during Daylight Saving Time? We don't use DST here.


   
serkan (February 14, 2011 at 03:10 AM)

It seems {DATE:Time-US} and {DATE:Time-EU} was wrong. US should show AM-PM and EU should show 24 hours. It's my bad. It's fixed now.

@abajan I think you want time zones it seems to be a bit tricky right now but I'll try to find a way for that. Currently all dates are represented in EST


   
primesunselect (February 21, 2011 at 06:45 AM)

This feature is great but I would like to be able to add a number of days to the date field.


   
Heeschen (February 27, 2011 at 12:43 PM)

in germany we have the following date format:
27.02.2011
Is there a chance that you implement this format.
Regards Marc


   
JotFormSupport (February 28, 2011 at 09:33 AM)

try this:

{DATE:d.m.Y}

or this:

{DATE:Date-DE}


   
BMGH (May 06, 2011 at 10:20 PM)

I have 2 'named' date fields - 'arrival' & 'departure'.

In my mails I want to clearly indicate what days are selected, using this format: 'monday 1 January 2012' (to avoid any misunderstanding: mmdd vs ddmm).

How do I format those dates in the notification?
I tried:
- date(arrival, l j F Y)
- {arrival: l j F Y}

Both don't work....

View Answer


   
ttrs (August 29, 2011 at 11:57 AM)

Can this date work for custom dates, for instance 'chosen date for training' ?

View Answer


   
Ivan (September 08, 2011 at 03:29 AM)

May I know the Date & Time is following which time zone?
And how am I going to set the time zone?
Thanks.

View Answer


   
SUASystems (March 06, 2012 at 06:52 PM)

Hello,

I was able to change the timezone Pacific Standard Time under the Settings menu in JotForm. However, when I use the following, all notifications are displayed in Eastern Standard Time (instead of PST).

{DATE:l, jS \of F Y \a\t g:i A T}
{DATE:Full-US}

Thanks for reading!

View Answer


   
anjaba (May 12, 2012 at 12:13 PM)

I need to be able to isolate the time only (not date AND time) in my spreadsheet from the submission date. Suggestions?

View Answer


   
dopravo (July 02, 2012 at 02:52 AM)

How do I get local time ?

View Answer


   
cakesfromscratch (November 18, 2012 at 11:34 PM)

Can I schedule an auto responder futher out than instant? if so how

View Answer


   
cakesfromscratch (November 18, 2012 at 11:35 PM)

Can I have a lead time X days out when the customer enters in my case a requested pick up date when using a date field?

Thanks

View Answer


   
Masalamedia (July 05, 2013 at 06:03 AM)

What if your field isn't called "DATE"? would the merge field in my email template be

{MyFieldName:Full-EU} for example?

View Answer


   
swathi (April 01, 2014 at 02:24 AM)

can i set notification to my date filed?
ex: i have start date and end date. i have to get email notification before one week of the end date

View Answer


   
swathi (April 02, 2014 at 12:57 AM)

hi, yes, i have to get a email notification before one week prior to the end date..

i am new to this jot form, never build any please help me

View Answer


   
otkweb (January 06, 2015 at 04:09 AM)

As mentioned in your post:
"...if you need more customized dates you can do it with standard PHP date formatting", but not working for this format:

{DATE:D d M Y}

Expected output: Tue 06 Jan 2015
Actual output: (empty)

View Answer


   
checkrecheck (April 24, 2015 at 09:56 AM)

Is the date and more specifically the time of the form SENT or when the user has opened the form page in order to start filling it?

View Answer


   
chinathinksbig (November 04, 2015 at 10:09 PM)

I need to add 7 days after the submission days and display it in the responder email, can I do that? If so, how?

Thanks

View Answer


   
Gerard NADEAU (April 29, 2016 at 04:27 PM)


It woould be very useful for all french people using jotform if you add a code using french usual display of dates otherwise than us display
A solution ?
Thanks
{DATE:l, jS \of F Y \a\t g:i A} Monday, 7th of February 2011 at 5:17 AM

View Answer


Send Comment