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