Easy Dates

Microsoft Dynamics NAV has always had some interesting mechanics around entering dates, and I’ve found that education about them is spotty. Depending on what you know already, this article could save you thousands of keystrokes per year.

The Microsoft Dynamics NAV Role Tailored Client has the great new date chooser:

    

However, as with many things, if you know some little keyboard tricks, you can speed things along. For example, most folks know that if you just enter ‘t’ into any Date Field, it will convert to today’s date.

Here’s a small table of what other ‘secret’ date translations there are, using today’s date of Friday, 4/29/2011 with a Working Date set to Monday, 4/25/2001:

If you enter…

…it becomes

Why?

t

4/29/2011

It presumes t is for TODAY

w

4/25/2011

It presumes w is for WORKDATE

mo

4/25/2011

It presumes mo is for Monday

tu

4/26/2011

It presumes tu is for Tuesday

we

4/27/2011

It presumes we is for Wednesday

th

4/28/2011

It presumes th is for Thursday

fr

4/29/2011

It presumes fr is for Friday

sa

4/30/2011

It presumes sa is for Saturday

su

5/1/2011

It presumes su is for Sunday. Note, it’s the following Sunday, not 4/24, the previous.

4

4/4/2011

It presumes you’ve only entered the day and will default the MONTH and YEAR parts based on your WORKDATE (not TODAY).

3/31

3/31/2011

It presumes you’ve entered the month and day, then it will default the YEAR part based on your WORKDATE (not TODAY).

m15

4/11/2011

It’s the 15th Monday in 2011.

th47

11/24/2011

It’s the 47th Thursday in 2011.

0429

4/29/2011

It assumes the YEAR per above and guesses the formatting. Note: 429 will not work, only 0429

 

NAV being a savvy world-travelled system, this is all dependent on the Language you’re using it in, and the Regional settings of your system. For example, in many parts of the world, ‘0429 is not a valid date’ but 2904 would be.

About the author

Jeremy Vyska Jeremy is a technology enthusiast and often plays the part of “wise old man” to his friends and peers.

Tags: ,