Get the date and time automatically in your reports!

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!