Skip to Content
0
Apr 09, 2008 at 07:46 PM

Print Layout Design - Date Format

111 Views

Hello,

In Checks for Payment Print Layout, I need to add the Check Date field in the format DDMMYYYY.

By default the Check Date is MM/DD/YY.

If I use the Formula Day(string), Month(string), Year(string) to get them seperately, the year looks fine, but 03/31/08 becomes 3132008, and 04/07/08 becomes 742008. The 0 is taken out.

Is there any way to keep the 0 in the dates so it would look like 31032008 and 07042008?

thank you,

Yi