Learn how to automatically retrive the date and time of your fields and your entries on your customized reports or emails!
Tip 1: Customize your reports with the Date and Time field.
Using the Date and Time field you can automatically obtain the date and/or time you have previously entered.
You can customize it with the following tags:
Your date field
Take as an example the date December 31, 2010.
Date:
##date##-> 31/12/2010Date in iso format:
##date:iso##-> 2010-12-31Year:
##date:year##-> 2010Month:
##date:month##-> 12Month in letters:
##date:month:label##-> decemberWeek:
##date:week##-> 52Day:
##date:daynumber##-> 31Day number in that week:
##date:weekday##-> 5Day of the week in letters:
##date:weekday:label##-> fridayShort text format:
##date:short##-> 31 Dec. 2010.Average sized text format:
##date:medium##-> December 31, 2010.Long text format:
##date:long##-> Friday 31 December 2010.
Your Time Field
Let's take for example the time 11:40.
Time:
##hour##-> 11:40Display hour without minutes:
##hour:hour##-> 11Minutes:
##hour:minute##-> 40
Your Date and Time Field
Take for example December 31, 2010, 11:40.
Date and Time:
##date_and_time##-> 31/12/2010 11:40Year:
##date_and_time:year##-> 2010Month:
##date_and_time:month##-> 12Month in letters:
##date_and_time:month:label##-> decemberWeek:
##date_and_time:week##-> 52Day:
##date_and_time:daynumber##-> 31Number of the day in that week:
##date_and_time:weekday##-> 5Day of the week in letters:
##date_and_time:weekday:label##-> fridayOnly the date:
##date_and_time:dateonly##-> 31/12/2010Only the date in iso format:
##date_and_time:dateonly:iso##-> 2010-12-31Show only time:
##date_and_time:timeonly##-> 11:40Only the hour:
##date_and_time:hour##-> 11Only the minutes:
##date_and_time:minute##-> 40Short text format:
##date_and_time:short##-> Dec 31, 2010 11:40.Average sized text format:
##date_and_time:medium##-> December 31, 2010 11:40.Long text format:
##date_and_time:long##-> Friday 31 December 2010 11:40.
Tip 2: Get the date and time of entry for your Photo, Geolocation, Barcode and/or NFC Tag fields.
Your date field
Take as an example the date December 31, 2010, 11:40 and 25 seconds.
Date and time when the photo was taken:
##photo1:time##-> 31/12/2010 11:40:25Date when the photo was taken:
##photo1:dateonly##-> 31/12/2010Date when the photo was taken in iso format:
##photo1:time:iso##-> 2010-12-31 11:40:25Year when the photo was taken:
##photo1:year##-> 2010Month when the photo was taken:
##photo1:month##-> 12Month when the photo was taken in letters:
##photo1:month:label##-> decemberDay of the month when the photo was taken:
##photo1:daynumber##-> 31Number of the day in that week when the photo was taken:
##photo1:weekday##-> 5Day of the week in letters when the photo was taken:
##photo1:weekday:label##-> friday
Your Time Field
Let's take for example hour 11:40 and 25 seconds.
Time when the photo was taken:
##photo1:timeonly##-> 11:40:25Hour when the photo was taken:
##photo1:hour##-> 11Minutes when the photo was taken:
##photo1:minute##-> 40Seconds when the photo was taken:
##photo1:second##-> 25
Tip 3: Get the date and time of your data.
Date and time of recording of the data
You can get this information with the tag##_answer_time##.
ℹ️ Note
We will take into account the date and time set on the mobile device.
In order to go further, here is a list of tags to customize your date and time.
Let us take for example December 31, 2010, 11:40 and 25 seconds. Date of recording the data in the iso format:##_answer_time:iso## -> 2010-12-31 11:40:25
Date when the data was recorded:
##_answer_time:dateonly##-> 31/12/2010Time when the data was recorded in iso format:
##_answer_time:dateonly:iso##-> 11:40:25Year when the data was recorded:
##_answer_time:year##-> 2010Month when the data was recorded:
##_answer_time:month##-> 12Month when the data was recorded in letters:
##_answer_time:month:label##-> decemberDay when the data was recorded:
##_answer_time:daynumber##-> 31Day number of the week when the data was recorded:
##_answer_time:weekday##-> 5Day of the week when the data was recorded:
##_answer_time:weekday:label##-> FridayTime when the data was recorded:
##_answer_time:hour##-> 11Time when the data was recorded in minutes:
##_answer_time:minute##-> 40Time when the data was recorded in seconds:
##_answer_time:second##-> 25
Date and time of the last data modification
You can get this information with the tag ##_update_time##.
ℹ️ Note
We will take into account the date and time of arrival on our servers.
In order to go further, here is a list of tags to customize your dates and times.
Take for example December 31, 2010, 11:40 and 25 seconds
Date and time when the data was modified in iso format:
##_update_time:iso##-> 2010-12-31 11:40:25Date when the data was modified:
##_update_time:dateonly##-> 31/12/2010Date when the data was modified in iso format:
##_update_time:dateonly:iso##-> 2010-12-31Year when the data was modified:
##_update_time:year##-> 2010Month when the data was modified:
##_update_time:month##-> 12Month when the data was modified in letters:
##_update_time:month:label##-> decemberDay when the data was modified:
##_update_time:daynumber##-> 31Day number of the week when the data was modified:
##_update_time:weekday##-> 5Day of the week when the data was modified:
##_update_time:weekday:label##-> FridayTime when the data was modified in hours:
##_update_time:hour##-> 11Time when the data was modified in minutes:
##_update_time:minute##-> 40Time when the data was modified in seconds:
##_update_time:second##-> 25
Tip 4: Get the date and time of generation of your custom export
A tag allows you to obtain the date and time of generation of your custom Word and/or Excel export.
Date and time of export generation:
You can get this information with the ##_generation_time## tag.
Here is a list of tags to customize your dates and times, with for example the 25th of January 2022 at 9:29 and 46 seconds.
Full date & time in numeric format: ##_generation_time##: 25/01/2022 09:29:46
Date only in numeric format: ##_generation_time:dateonly##: 25/01/2022
Time only in numeric format: ##_generation_time:timeonly##: 09:29
Short text format: ##_generation_time:short##: 25 Jan 2022 at 09:29:46
Medium text format: ##_generation_time:medium##: 25 Jan 2022 at 09:29:46
Long text format: ##_generation_time:long##: Tuesday 25 January 2022 at 09:29:46
Date and time in iso format: ##_generation_time:iso##: 2022-01-25 09:29:46
Only date in iso format: ##_generation_time:dateonly:iso##: 2022-01-25
Year: ##_generation_time:year##: 2022
Month: ##_generation_time:month##: 01
Month in words: ##_generation_time:month:label##: January
Week: ##_generation_time:week##: 04
Day: ##_generation_time:daynumber##: 25
Day of the week in numbers: ##_generation_time:weekday##: 2
Day of the week in words: ##_generation_time:weekday:label##: Tuesday
Hours: ##_generation_time:hour##: 09
Minutes: ##_generation_time:minute##: 29