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/2010 - Date in iso format:
##date:iso##-> 2010-12-31 - Year:
##date:year##-> 2010 - Month:
##date:month##-> 12 - Month in letters:
##date:month:label##-> december - Week:
##date:week##-> 52 - Day:
##date:daynumber##-> 31 - Day number in that week:
##date:weekday##-> 5 - Day of the week in letters:
##date:weekday:label##-> friday - Short 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:40 - Display hour without minutes:
##hour:hour##-> 11 - Minutes:
##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:40 - Year:
##date_and_time:year##-> 2010 - Month:
##date_and_time:month##-> 12 - Month in letters:
##date_and_time:month:label##-> december - Week:
##date_and_time:week##-> 52 - Day:
##date_and_time:daynumber##-> 31 - Number of the day in that week:
##date_and_time:weekday##-> 5 - Day of the week in letters:
##date_and_time:weekday:label##-> friday - Only the date:
##date_and_time:dateonly##-> 31/12/2010 - Only the date in iso format:
##date_and_time:dateonly:iso##-> 2010-12-31 - Show only time:
##date_and_time:timeonly##-> 11:40 - Only the hour:
##date_and_time:hour##-> 11 - Only the minutes:
##date_and_time:minute##-> 40 - Short 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:25 - Date when the photo was taken:
##photo1:dateonly##-> 31/12/2010 - Date when the photo was taken in iso format:
##photo1:time:iso##-> 2010-12-31 11:40:25 - Year when the photo was taken:
##photo1:year##-> 2010 - Month when the photo was taken:
##photo1:month##-> 12 - Month when the photo was taken in letters:
##photo1:month:label##-> december - Day of the month when the photo was taken:
##photo1:daynumber##-> 31 - Number of the day in that week when the photo was taken:
##photo1:weekday##-> 5 - Day 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:25 - Hour when the photo was taken:
##photo1:hour##-> 11 - Minutes when the photo was taken:
##photo1:minute##-> 40 - Seconds 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/2010 - Time when the data was recorded in iso format:
##_answer_time:dateonly:iso##-> 11:40:25 - Year when the data was recorded:
##_answer_time:year##-> 2010 - Month when the data was recorded:
##_answer_time:month##-> 12 - Month when the data was recorded in letters:
##_answer_time:month:label##-> december - Day when the data was recorded:
##_answer_time:daynumber##-> 31 - Day number of the week when the data was recorded:
##_answer_time:weekday##-> 5 - Day of the week when the data was recorded:
##_answer_time:weekday:label##-> Friday - Time when the data was recorded:
##_answer_time:hour##-> 11 - Time when the data was recorded in minutes:
##_answer_time:minute##-> 40 - Time 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:25 - Date when the data was modified:
##_update_time:dateonly##-> 31/12/2010 - Date when the data was modified in iso format:
##_update_time:dateonly:iso##-> 2010-12-31 - Year when the data was modified:
##_update_time:year##-> 2010 - Month when the data was modified:
##_update_time:month##-> 12 - Month when the data was modified in letters:
##_update_time:month:label##-> december - Day when the data was modified:
##_update_time:daynumber##-> 31 - Day number of the week when the data was modified:
##_update_time:weekday##-> 5 - Day of the week when the data was modified:
##_update_time:weekday:label##-> Friday - Time when the data was modified in hours:
##_update_time:hour##-> 11 - Time when the data was modified in minutes:
##_update_time:minute##-> 40 - Time 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
Share your experience with Kizeo Forms!
