Date in format dd.mm.yyyy

poppins

Hi everyone,

How to get a date in format dd.mm.yyyy in RDLC reports?

Thanks in advance

lakshman

you can set the property like below.

In RDLC Layout-->textbox -->properties-->Number Tab--> Date-->select 31.01.00

I hope you will get it.

Jan_Veenendaal

Instead of changing the RDLC layout you should change the source expression for the column in NAV.
If you have a date variable called MyDate then the source expression should be:

FORMAT(MyDate,0,'<day,2>.<month,2>.<year4>')

or - if you want to print the Posting Date - you could use:

FORMAT("Posting Date",0,'<day,2>.<month,2>.<year4>')

lakshanvindana

May I know the meaning of "0" after the Posting date.
FORMAT("Posting Date",0,'<day,2>.<month,2>.<year4>')

Good suggestion.
Thank you.

Jan_Veenendaal

Hi lakshanvindana,

The 0 is the length of the resulting string, where 0 means: return the complete string.

See MSDN documentation on https://msdn.microsoft.com/en-us/library/dd301367(v=nav.80).aspx