Inconsistant Date Format

lgp

Hi,
Our client has noticed that when the AP check prints, the check date prints as 07/25/2010, but the document date on the stub prints 7/25/2010. They would like the month to print as 2 digits in both places. I have tried several things to get the Document Date to print with 2 digits, including changing regional settings in windows, changing the format property in the RTC to mm/dd/yyyy (this resulted in 00/25/2010), removing the format property in RTC (which printed the date and time), and attempting to use the FORMAT(DocDate,<Month,2>/<Day,2>/<Year4> in the code, but none of these have worked. ](*,) Has anyone else had to make this change?
Thanks!

DenSter

Instead of:

FORMAT(DocDate,<Month,2>/<Day,2>/<Year4>)

try:

FORMAT(DocDate,0,'<Month,2>/<Day,2>/<Year4>')

The C/SIDE Reference Guide has information on all syntax like this. Click Help, C/SIDE Reference Guide, and enter 'FORMAT' into the search tab.

DenSter

You had the same question before by the way: viewtopic.php?f=32&t=37797
Forgot about that one?

deV.ch

by the way: mm/dd/yyyy in RDLC layout doens't work because mm = minutes and not months, if you want to have the month you need a capital M: MM/dd/yy

lgp

DenSter wrote:

You had the same question before by the way: viewtopic.php?f=32&t=37797
Forgot about that one?

Actually, no, that was a different question regarding printing the date as text (i.e. October 25, 2010) vs. short date (10/25/10).

lgp

deV.ch wrote:

by the way: mm/dd/yyyy in RDLC layout doens't work because mm = minutes and not months, if you want to have the month you need a capital M: MM/dd/yy

Thanks so much - you have solved my problem!