SBX - Search With Button

SBX - Forum Post Title

How to display Date in dd/mm/yyyy

Microsoft Dynamics NAV Forum

jsshivalik asked a question on 23 Aug 2017 11:48 AM
My Badges

Question Status

Verified

Hi

   How to display Date in dd/mm/yyyy in reports

Thanks

Reply
Mohana Yadav responded on 23 Aug 2017 12:15 PM
Verified Answer

Did you try

Format(date,0,'<Day,2>/<Month,2>/<Year4>');

Reply
Suresh Kulla responded on 23 Aug 2017 1:48 PM
Suggested Answer
Vignesh M responded on 10 Oct 2017 6:47 AM
Suggested Answer

Hi,

You can also set Custom format (dd/MM/yyyy) in text box property.

Reply
Cindrella Rajkumar responded on 13 Jun 2018 1:10 AM
My Badges

thank you so much jsshivalik for for correct answer .

Reply
Khoa Nguyen responded on 13 Jun 2018 5:45 AM
My Badges

Hi Cindrella,

I think it is Mohana :-)

Have a nice day to you all!

Reply
Mohana Yadav responded on 23 Aug 2017 12:15 PM
Verified Answer

Did you try

Format(date,0,'<Day,2>/<Month,2>/<Year4>');

Reply
Suresh Kulla responded on 23 Aug 2017 1:48 PM
Suggested Answer
Vignesh M responded on 10 Oct 2017 6:47 AM
Suggested Answer

Hi,

You can also set Custom format (dd/MM/yyyy) in text box property.

Reply

SBX - Two Col Forum

SBX - Migrated JS