{"id":961,"date":"2016-10-03T19:50:57","date_gmt":"2016-10-03T17:50:57","guid":{"rendered":"http:\/\/blog.systemconnect.dk\/?p=961"},"modified":"2022-07-05T13:05:23","modified_gmt":"2022-07-05T11:05:23","slug":"dynamics-nav-og-udenlandske-datoformler","status":"publish","type":"post","link":"https:\/\/scblog.lynge.org\/?p=961","title":{"rendered":"Dynamics NAV og udenlandske datoformler"},"content":{"rendered":"

Dynamic NAV har en indbygget felttype der hedder date formula\u00a0(datoformel)\u00a0– og den er ret intelligent.<\/p>\n

Ideen er at man kan angive en datoformel – alts\u00e5 noget der bruges til at beregne en ny dato ud fra en eksisterende. Det kan fx v\u00e6re en betalingsbetingelse (LM+30D = L\u00f8bende M\u00e5ned + 30 dage) og formlerne kan v\u00e6re ret komplekse.<\/p>\n

I Dynamic NAV er det endda s\u00e5 intelligent at Dynamic NAV gemmer dem i databasen p\u00e5 en sprog-neutral m\u00e5de, mens den viser dem oversat til brugerens sprog.<\/p>\n

Jamen hvad s\u00e5 hvis jeg skal angive\u00a0en datoformel\u00a0i programkoden og ikke \u00f8nsker at det skal v\u00e6re sprogafh\u00e6ngig?<\/strong><\/p>\n

S\u00e5 tilbyder NAV ganske simpelt at du angiver dem p\u00e5 ENU (English\/United States) sproget\u00a0ved at s\u00e6tte < og > omkring dem\u00a0– fx “<CM+30D>”.<\/p>\n

Ulempen er naturligvis hvis du \u00f8nsker at kunne manipulere med de sproguafh\u00e6ngige former selv – eller blot \u00f8nsker at vide hvilke tegn der har betydning p\u00e5 andre sprog.<\/p>\n

Nu har Dynamic NAV RET mange forskellige sprog, men vi har lavet en tabel over de v\u00e6rdier vi kender. Du er velkommen til at bidrage med andre:<\/p>\n\n\n\n\n\n\n\n\n\n
SPROG\\BETYDNING<\/b><\/td>\nUgedag<\/b><\/td>\nL\u00f8bende<\/b><\/td>\nDag<\/b><\/td>\nUge<\/b><\/td>\nM\u00e5ned<\/b><\/td>\nKvartal<\/b><\/td>\n\u00c5r<\/b><\/td>\nFinansperiode<\/b><\/td>\n<\/tr>\n
DAN<\/td>\nUD<\/td>\nL<\/td>\nD<\/td>\nU<\/td>\nM<\/td>\nK<\/td>\n\u00c5<\/td>\nP<\/td>\n<\/tr>\n
DEU<\/td>\nWT<\/td>\nL<\/td>\nT<\/td>\nW<\/td>\nM<\/td>\nQ<\/td>\nJ<\/td>\nP<\/td>\n<\/tr>\n
ENU<\/td>\nWD<\/td>\nC<\/td>\nD<\/td>\nW<\/td>\nM<\/td>\nQ<\/td>\nY<\/td>\nP<\/td>\n<\/tr>\n
ITA<\/td>\nGS<\/td>\nC<\/td>\nG<\/td>\nS<\/td>\nM<\/td>\nT<\/td>\nA<\/td>\nP<\/td>\n<\/tr>\n
NOR<\/td>\nUD<\/td>\nN<\/td>\nD<\/td>\nU<\/td>\nM<\/td>\nK<\/td>\n\u00c5<\/td>\nP<\/td>\n<\/tr>\n
SVE<\/td>\nVD<\/td>\nL<\/td>\nD<\/td>\nV<\/td>\nM<\/td>\nK<\/td>\n\u00c5<\/td>\nP<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Husk – du er velkommen til at bidrage med flere til listen hvis du kender dem.<\/p>\n

Eksempler p\u00e5 datoformler (til inspiration)<\/strong><\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Datoformel (ENU)<\/b><\/td>\nBetydning<\/b><\/td>\n<\/tr>\n
<8D><\/td>\n+ 8 dage<\/td>\n<\/tr>\n
<CM+30D><\/td>\nL\u00f8bende m\u00e5ned + 30 dage<\/td>\n<\/tr>\n
<-CM><\/td>\nF\u00f8rste dag i indev\u00e6rende m\u00e5ned<\/td>\n<\/tr>\n
<CM><\/td>\nL\u00f8bende m\u00e5ned (dvs. sidste dag i indev\u00e6rende m\u00e5ned)<\/td>\n<\/tr>\n
<1M-CM><\/td>\nF\u00f8rste dag i n\u00e6ste m\u00e5ned<\/td>\n<\/tr>\n
<1M+CM><\/td>\nSidste dag i n\u00e6ste m\u00e5ned<\/td>\n<\/tr>\n
<-D15><\/td>\nDag nr. 15 i denne m\u00e5ned<\/td>\n<\/tr>\n
<D15><\/td>\nDag nr. 15 i n\u00e6ste m\u00e5ned<\/td>\n<\/tr>\n
<W2><\/td>\nS\u00f8ndag i uge 2 i n\u00e6ste m\u00e5ned (ugen g\u00e5r fra Mandag-S\u00f8ndag i NAV)<\/td>\n<\/tr>\n
<CY-1Y><\/td>\nSidste dag i sidste kalender\u00e5r<\/td>\n<\/tr>\n
<CW+2D+1W><\/td>\nEn uge efter n\u00e6ste tirsdag<\/td>\n<\/tr>\n
<D10+WD2><\/td>\nDen f\u00f8rstkommende tirsdag efter d. 10. i n\u00e6ste m\u00e5ned<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Bem\u00e6rk alle er her angivet i deres ENU-form (derfor er der < og > omkring dem). Du kan jo evt. selv overs\u00e6tte dem til det \u00f8nskede sprog via ovenst\u00e5ende tabel<\/p>\n","protected":false},"excerpt":{"rendered":"

Dynamic NAV har en indbygget felttype der hedder date formula\u00a0(datoformel)\u00a0– og den er ret intelligent. Ideen er at man kan angive en datoformel – alts\u00e5 noget der bruges til at beregne en ny dato ud fra en eksisterende. Det kan … L\u00e6s resten →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[40,41,38,32,35,36],"tags":[15,43,11,54,52,23,14,42,44,31,20],"class_list":["post-961","post","type-post","status-publish","format-standard","hentry","category-c5-support","category-c5-teknik","category-dynamics-c5","category-dynamics-nav","category-nav-support","category-nav-teknik","tag-business-solutions","tag-c5","tag-dynamics","tag-dynamics-c5","tag-dynamics-nav","tag-hint","tag-microsoft","tag-nav","tag-navigator","tag-navision","tag-udokumenteret"],"_links":{"self":[{"href":"https:\/\/scblog.lynge.org\/index.php?rest_route=\/wp\/v2\/posts\/961","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/scblog.lynge.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/scblog.lynge.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/scblog.lynge.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/scblog.lynge.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=961"}],"version-history":[{"count":4,"href":"https:\/\/scblog.lynge.org\/index.php?rest_route=\/wp\/v2\/posts\/961\/revisions"}],"predecessor-version":[{"id":1209,"href":"https:\/\/scblog.lynge.org\/index.php?rest_route=\/wp\/v2\/posts\/961\/revisions\/1209"}],"wp:attachment":[{"href":"https:\/\/scblog.lynge.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=961"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/scblog.lynge.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=961"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/scblog.lynge.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=961"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}