Formatting Dates in a Report

By default, merged dates (like '[[EndedOn]]' in a Site Visit Report) will appear in the format '01/01/2020' or 'MM/DD/YYYY'.  However, you can change how the dates are displayed by adding some text to the merge field.

 

If you want the day to appear before the year, for example, "[[EndedOn|d/MM/yyyy]]" will appear as 7/3/2021

"[[EndedOn|MMMM d yyyy]]" will appear as March 7 2021

"[[EndedOn|MMM d yyyy]]" will appear as Mar 7 2021

"[[EndedOn|d MMMM yy]]" will appear as 7 March 21

 

As another example, if you want the time a photograph was taken to be inserted into a photo block, you could use "[[TakenOn|hh:mm]]"

 

You can find full documentation for date styling here (link to third party site).

 

 

Have more questions? Submit a request

0 Comments

Article is closed for comments.
Powered by Zendesk