Date format YYYYMMMDD

Developer101 Member Posts: 569

2018-09-09 in NAV Three Tier

How to achieve YYYYMMMDD date format in NAV e.g; 2018Sep09

Thanks

United Kingdom

0

Answers

• 

  Slawek_Guzek Member Posts: 1,690

  2018-09-09

  SomeDateText := FORMAT(090918D, 0, '<Year4><Month Text,3><Day,2>')
  

  Slawek Guzek
  Dynamics NAV, MS SQL Server, Wherescape RED;
  PRINCE2 Practitioner - License GR657010572SG
  GDPR Certified Data Protection Officer - PECB License DPCDPO1025070-2018-03

  0
• 

  RockWithNAV Member Posts: 1,184

  2018-09-11

  This will help
  
  https://docs.microsoft.com/en-us/dynamics-nav/format-function--code--text-

  Thanks
  
  Blog - rockwithnav.wordpress.com/
  Twitter - https://twitter.com/RockwithNav
  Facebook - https://facebook.com/rockwithnav/

  0