Date Format

RogerSheets · 2011-07-28

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 · 2011-07-28

Pressing F1 is easier than posting here..

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

RogerSheets · 2011-07-28

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 · 2011-07-28

are you saying it still isn't working?

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

RogerSheets · 2011-07-28

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

thanks for the quick responses.

Savatage · 2011-07-28

Yeah, Year4 has no comma..go figure.

mohana_cse06 · 2011-07-29

mohana_cse06 wrote:
Pressing F1 is easier than posting here..
<month,2>/<day,2>/<year4>

:thumbsup:

Date Format

Comments

Categories