SSRS Report: How Do I Change the Format of "TransDate" from (mm/dd/yyyy) TO (dd/mm/yyyy) Form in My Report?

(0) Share

Report

Posted on by Momochi

1,013

Hello awesome community i'm new to AX and report development i'm still learning and I seek your help if you please :)

I'm developing an SSRS report using DP class, I have a "TransDate" field from LedgerJournalTrans Table but it shows on like this:

I have tried to change it in Visual Studio using this window:

But it did not have a dd/mm/yyyy option unfortunately.

I believe it should be done in DP class with code, if you show me the code or refer me to a reference, it would be appreciated

Thanks in advance!

*This post is locked for comments

I have the same question (0)

All responses (6)

Answers (3)

Suggested answer

Community Member on at

Like (1)

Report

RE: SSRS Report: How Do I Change the Format of "TransDate" from (mm/dd/yyyy) TO (dd/mm/yyyy) Form in My Report?

You can use the function: Date2Str().

Is a global function and you can set the parameters to return the value the way you need:

static void Job2(Args _args)

{

date currentDate = today();

str s;

int iEnum;

;

s = date2Str

(currentDate,

321,

DateDay::Digits2,

DateSeparator::Hyphen, // separator1

DateMonth::Digits2,

DateSeparator::Hyphen, // separator2

DateYear::Digits4

);

info("Today is: " + s);

}

/** Example Infolog output

Message (12:36:21 pm)

Today is: 2009-01-13

**/

Was this reply helpful? Yes No
Verified answer

Sohaib Cheema 48,663 User Group Leader on at

Like (2)

Report

RE: SSRS Report: How Do I Change the Format of "TransDate" from (mm/dd/yyyy) TO (dd/mm/yyyy) Form in My Report?

Hi,

You can do this in many ways, without any line of code.

with the current way, that you are trying, select the last choice called 'Custom' and then in the empty box add dd/MM/yyyy

that should work for you.

Was this reply helpful? Yes No
Verified answer

Sebastian Mankowski 305 on at

Like (1)

Report

RE: SSRS Report: How Do I Change the Format of "TransDate" from (mm/dd/yyyy) TO (dd/mm/yyyy) Form in My Report?

Hi Momochi...

I can see two ways to achieve your goal:

1. You can use TextBox expression and use following command: =FORMAT(Fields!Dataset_Field_Name_Here.Value,"dd/MM/yyyy")

2. Use TextBox Custom format as presented on following screen:

Let me know if any of the above works for you.

Sebastian

Was this reply helpful? Yes No
Verified answer

startax 1,845 on at

Like (1)

Report

RE: SSRS Report: How Do I Change the Format of "TransDate" from (mm/dd/yyyy) TO (dd/mm/yyyy) Form in My Report?

Hi Momochi,

Sohaib Cheema is right no need to write code in DP class. You can achieve this by Custom option in format put "dd/MM/yyyy"

Was this reply helpful? Yes No
Momochi 1,013 on at

Like (0)

Report

RE: SSRS Report: How Do I Change the Format of "TransDate" from (mm/dd/yyyy) TO (dd/mm/yyyy) Form in My Report?

Works like a charm! simple and straight forward thank you guys for your kind help and time!

Was this reply helpful? Yes No
TestBot 950 on at

Like (0)

Report

RE: SSRS Report: How Do I Change the Format of "TransDate" from (mm/dd/yyyy) TO (dd/mm/yyyy) Form in My Report?

Hi,

What about if my date field is a string and i need to print in dd/MM/yyyy format in a report?

how to acheive this scenario?pls suggest

Was this reply helpful? Yes No