How do I format the <<TODAY_>> field in my report template. As you can see the due dates in the report shows dd/mm/yyyy but the heading shows mm/dd/yyyy.
Also a user added a comment (shown in red) and his comment shows a date of entry in mm/dd/yyyy. In the app and in the google sheet it shows as dd/mm/yyyy.
To avoid confusion can I set dates to 8 May 2019 for example? How would this expression look for the report template?
Solved! Go to Solution.
@Riki_Armstrong
Here is the template language
<<CONCATENATE(RIGHT(โ0โ&DAY(TODAY()),2),"/",RIGHT(โ0โ&MONTH(TODAY()),2),"/",YEAR(TODAY()))>>
As long as you specify between left & right double chevrons, you can specify/construct any AppFormula expression you like in a workflow template. In above expression you can replace TODAY() with any [DATE] column you like in your template:
<<CONCATENATE(RIGHT(โ0โ&DAY([Due Date]),2),"/",RIGHT(โ0โ&MONTH([Due Date]),2),"/",YEAR([Due Date]))>>
User | Count |
---|---|
37 | |
31 | |
28 | |
22 | |
18 |