Tuesday, 26 April 2011

NAV Date Codes

Date can also be enter in Microsoft Dynamics NAV with some codes. These codes will work only for the field ‘Data Type’ Date.

If your System Date is (26/04/2011 Tuesday) and Work Date is (25/03/2011 Friday), you get following output in Date Field for the Code.


Required Date NAV Code Output in Date Field
System Date t 26/04/2011
Work Date w 25/03/2011
Closing Date c C25/03/11
Monday (Work Date week) m 21/03/2011
Tuesday (Work Date week) tu 22/03/2011
Wednesday (Work Date week)   we 23/03/2011
Thursday (Work Date week) th 24/03/2011
Friday (Work Date week) f 25/03/2011
Saturday (Work Date week) s or sa 26/03/2011
Sunday (Work Date week) su 27/03/2011

0 comments:

Powered by Ourblogtemplates.com

Back to TOP