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!
0
Comments
-Mohana
http://mohana-dynamicsnav.blogspot.in/
https://www.facebook.com/MohanaDynamicsNav
i did press F1 from within the format field and found nothing within the help in nav, which is why i posted here.
FORMAT("Your Date",0,'<Month,2>/<Day,2>/<year4>');
http://www.BiloBeauty.com
http://www.autismspeaks.org
thanks for the quick responses.
http://www.BiloBeauty.com
http://www.autismspeaks.org
:thumbsup:
-Mohana
http://mohana-dynamicsnav.blogspot.in/
https://www.facebook.com/MohanaDynamicsNav