I have been struggling to format the date such as NOW() and TODAY() in an Australia format when using a Document Template to generate a Scheduled Report. Even by changing the locale of the tables or changing the document properties it didnโt make any difference. So I ended up creating the following. There are probably better ways as Iโm not a programmer so Iโm open to improvements. Hopefully, this will help someone else:
<<IF(DAY(NOW())<10, CONCATENATE("0", DAY(NOW())),DAY(NOW()))>>/<<IF(MONTH(NOW())<10, CONCATENATE("0", MONTH(NOW())),MONTH(NOW()))>>/<<SUBSTITUTE(YEAR(NOW()),โ,โ,โโ)>>
Solved! Go to Solution.
How about:
<<RIGHT(("0" & DAY(NOW())), 2) & "/" & RIGHT(("0" & MONTH(NOW())), 2) & "/" & (YEAR(NOW()) & "")>>
Wellโฆ thatโs okay.
How about:
<<RIGHT(("0" & DAY(NOW())), 2) & "/" & RIGHT(("0" & MONTH(NOW())), 2) & "/" & (YEAR(NOW()) & "")>>
Much nicer, thanks Steve!
User | Count |
---|---|
41 | |
28 | |
28 | |
23 | |
13 |