web

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

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) format date

Microsoft Dynamics AX (Archived)

format date

(0) Share

Report

Report

Posted on by Community Member

Hello.

I am using report.

In each field of the report there is datamethod.

I couldn't find something better, but I overrided on the datamethod, and put them a code that convert date to string.

the method I choose is strfmt, but I didn't find a way to convert to a specific format :

i.e dd/mm/yyyy.

How can I convert data field (of a table in database) to string with a specific format?

Thanks :)

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (4)

Answers Img

Answers (0)

Sort by

Suggested answer

Community Member on at

Like (0)

Report
Copy link

Link copied!

Try using the built-in function date2str() method.

msdn.microsoft.com/.../aa857241.aspx

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

What is the parameter : "Day". and where can I find information for the value, I should give (i.e : 321, for the link you gave) ?

Thanks :)

Was this reply helpful? Yes No
Luegisdorf 1,930 on at

Like (0)

Report
Copy link

Link copied!

123 equal day-month-year

321 equals year-month-day

Means:

1 for day

2 for month

3 for year

I suggest you use it that way:

date2str(date, 123, 2, 4, 2, 4, 2);

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report
Copy link

Link copied!

Most of the parameters are enumerations. Try leaving most at auto and see if the format meets with your approval. For example:

strDate = date2str(thisDate, 321, DateDay::Auto, DateSeparator::Auto, DateMonth::Auto, DateSeparator::Auto, DateYear::Auto);

The sequence should indicate which parts of the date should be in which order, with 1 = days, 2 = months, and 3 = years. Some examples

123 = day / month / year

213 = month / day / year

321 = year / month / day

132 = year / day / month

etc.

EDIT: ah, beaten to the punch. Patrick is right though.

Was this reply helpful? Yes No

Helpful resources

News and Announcements

🚀 Season of Sharing Community Challenge Launch!

Ask A Community Pro

Introducing our New Video Series: Community Spotlight

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

CP04-islander 21

#2

#2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans