Dynamics 365 F&O/AX Dynamics 365 CE / CRM Dynamics GP Business Central / NAV UG Dynamics SL Power Platform Fabric UG MS Copilot UG

[David Wiser]

While experimenting with date ranges this morning I came across an oddity I cannot decipher.  Using a workdate of today (Friday, 2/16/18), I type “SA-1” in a date field which NAV translated as 1/6/18.  Anyone care to explain.  This one has me stumped.

——————————
Dave Wiser
Controller
Beckwith & Kuffel
Seattle WA
——————————

[David Wiser]

Solved my own question (which may come in handy to some).  “SA” is the code for Saturday.  Following “SA” with a number (SA3) or including the dash (SA-3) results in what Saturday of the year that is.  So, SA3 returns the third Saturday of the year (1/20/18).  SA1 (or SA-1) results in the first Saturday of the year (1/6/18).

Will have to think how this can help me.

——————————
Dave Wiser
Controller
Beckwith & Kuffel
Seattle WA
——————————
——————————————-

[Kim Dallefeld]

Thanks for the tip Dave!

——————————
Kim Dallefeld
VP Professional Services
Syte Consulting Group
kdallefeld@sytecg.com

Past NAVUG Board Chairman
NAVUG Programming Committee
——————————
——————————————-

[Holly Kutil]

Great Discovery!

——————————
Holly Kutil ~ NAVUG All-Star
American Ring/CIO
Solon, OH 44139
**Great Lakes Chapter**
?? Women In Dynamics ??
——————————
——————————————-

[Jenn Claridge]

?Thanks Dave!

An interesting tip I didn’t know.

——————————
Jenn Morton
Manufacturing Consultant
Sabre Limited
Cambridge Ontario Canada
——————————
——————————————-

[Susan Swank]

Hi Dave,

Entering a date as a weekday followed by a week number, for example, SA1 or SA-1 will result in  Saturday in week 1.
SA-1-19 will result in Saturday in Week 1 of Year 2019.

——————————
Susan Swank
IT Support
DSI (Dywidag Systems Intl)
Bolingbrook IL
——————————
——————————————-