Wednesday, April 20, 2022

how to display date without time in report using x++

Today we see how to display only date in report in D365FO. 


If we add date field in table it stores the data in date with time(12 am). If you see that field in form it will display only date but in report it will display both. To avoid this we need to use the expression. Just check below.


 




Use below expression in respective field box.

=Format(Fields!Culumn_Date.value,"dd/MM/yyyy")

-----------------------------or-------------------------------------------

=FormatDateTime(Fields!StartDate.Value, DateFormat.ShortDate)


OutPut:




Keep Daxing!!


No comments:

Post a Comment