Display Date as 02-Apt-17

(0) Share

Report

Posted on by jsshivalik

3,099

I want to display date as 02-May-17. If date is 02/05/2017 in record. This is reqd in report.

Thanks

*This post is locked for comments

I have the same question (0)

All responses (8)

Answers (1)

Suggested answer

Maneesha 5,891 on at

Like (0)

Report

RE: Display Date as 02-Apt-17

hi

go to your relevant report and follow the instruction given on below link

msdn.microsoft.com/.../dd301174.aspx

Was this reply helpful? Yes No
jsshivalik 3,099 on at

Like (0)

Report

RE: Display Date as 02-Apt-17

Hi

Can u pls help how to write in Source Exp. I have written but not working. Format("Posting Date",'did-mmm-YY').

Thanks.

Was this reply helpful? Yes No
mmv 11,471 on at

Like (1)

Report

RE: Display Date as 02-Apt-17

FORMAT(TODAY,0,'<Day,2>-<Month Text>-<Year4>')

Was this reply helpful? Yes No
jsshivalik 3,099 on at

Like (0)

Report

RE: Display Date as 02-Apt-17

Hi

I want month name 3 character like Apr. Year 2 digits.

Thanks

Was this reply helpful? Yes No
Suggested answer

Maneesha 5,891 on at

Like (1)

Report

RE: Display Date as 02-Apt-17

<Day,2><Filler Character, >. <Month Text,3> <Year4>

Was this reply helpful? Yes No
mmv 11,471 on at

Like (1)

Report

RE: Display Date as 02-Apt-17

FORMAT(TODAY,0,'<Day,2>-<Month Text,3>-<Year>')

Was this reply helpful? Yes No
Suggested answer

Amol Salvi 18,698 on at

Like (0)

Report

RE: Display Date as 02-Apt-17

Go to RDLC layout and on textbox properties

Select desire format and check

Was this reply helpful? Yes No
Verified answer

Binesh 7,885 on at

Like (1)

Report

RE: Display Date as 02-Apt-17

Hello use this

FORMAT("Posting Date",0,'<Day,2>-<Month Text,3>-<Year>')

Note:

If Posting date is 05.02.2017 then it reruns like: 02-May-17

Was this reply helpful? Yes No