Date Format Dataport

zahizahi Member Posts: 2
How to encrypt this date format:
21-03-2017 for 3 new fields with these values:
Day = 21
Month = 03
Year = 2017

It's a data port where I'm going to export Posting date from Item Ledger Entry.
Version of Navision is 3.70


  • vaprogvaprog Member Posts: 1,067
    Hi zahi

    You may use
    FORMAT("Posting Date",0,'<Day,2>-<Month,2>-<Year4>')
  • zahizahi Member Posts: 2
    vaprog Thank you for your help, I could use your answer
Sign In or Register to comment.