Date format in Nav2018

Hi All,

In NAV 2018 report I want few different date formats like : 31 July 2018, Tuesday, November 21, 2018.

I tried it with available date options in report but its not working.

One more thing I am getting date from =Code.GetData(x,y).

Any suggestion?

Hi Nikita,

Click on textbox go to properties, select Date and then you can get various dates format Enjoy.



Hi Sachin,

I already tried it but that is not working.

Personally I have always formatted the date, before it get’s into Visual Studio. Meaning while in NAV, then use the Format directly on the data. Makes it much easier. [emoticon:c4563cd7d5574777a71c318021cbbcc8]

How to change date format on Dataset (Expected date format 31,January,2018)

Hope This Helps You…/month-name-from-a-date

Just use the C/Side FORMAT function. F5 will show you how to use, there are many different default formats, but check this (oldie-but-goodie):