Date Format

RogerSheets

I am having an issue formatting the "Document Date" field of the sales invoice header on a printed invoice.

currently it is showing 10/27/07 i need it to show 10/27/2007

i have tried using <month,2>/<day,2>/<year,4> and i get 10/27/0007

any ideas would be appreciated
TIA!

mohana_cse06

Pressing F1 is easier than posting here..

<month,2>/<day,2>/<year4>

RogerSheets

you must have missed in my post where i tried the code you suggest and didnt get the results i anticipated ..

i did press F1 from within the format field and found nothing within the help in nav, which is why i posted here.

Savatage

are you saying it still isn't working?

FORMAT("Your Date",0,'<Month,2>/<Day,2>/<year4>');

RogerSheets

wait .. <year4> is different from <year,4> ... i guess that was my problem.

thanks for the quick responses.

Savatage

Yeah, Year4 has no comma..go figure.

mohana_cse06

mohana_cse06 wrote:

Pressing F1 is easier than posting here..

<month,2>/<day,2>/<year4>

:thumbsup: