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.
[…] Bron : Jeremy.Vyska.Info Lees meer… […]