web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Finance | Project Operations, Human Resources, ... What is the best way t...

Finance | Project Operations, Human Resources, ...

Suggested Answer

What is the best way to format a date ?

(1) Share

Report

Report

Posted on by Teevo

407

Hi,

When we want to store date to a string, what is the best way to do it with a date format ?

Can we use only STRFMT(), let say we want to add some text as well, like -> str sDate = strFmt(/Today is %1/, systemdateget()) but with addition of specifying date format like /DD-MM-YYYY/

or should we convert the date using Date2Str() function then use the result in strFmt() ?

Thanks

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Martin Dráb 240,845 Most Valuable Professional on at

Like (1)

Report
Copy link

Link copied!

Hard-coding a date format sounds like a bad idea in this case. You should respect the format used in the user session, otherwise the user will see different format in your message than in the rest of F&O. It looks weird and it may lead to errors, e.g. when the user uses the US format starting with the month, not the day.

But in general, date2str() is an option. I also like .NET formatting functions, where you can use format string such as dd-MM-yyyy. It's usually easier to understand.

Join the conversation

Helpful resources

Quick Links

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1

Martin Dráb 515 Most Valuable Professional

#2

André Arnaud de Cal... 417 Super User 2026 Season 2

#3

CU10121822-0 360

Last 30 days Overall leaderboard

Featured topics

End-of-life Announcement for Microsoft Dynamics GP

License usage reporting (in-app and PPAC) with Entra dynamic groups

Product updates

Dynamics 365 release plans