Retrieve month name from date.

Business Central/NAV Developers Forum
1

Hi guys…

Im new to dynamics navision technical side.

i want to show month name in a report. Is it possible to do it…? how can i solve this problem…??

[*-)]

2

you may code this in the source expression in text box:

FORMAT(TODAY,0,4)

3

i need to show month from date in sales line table. So i dont want current date.

i already code like follows:

i:=DATE2DMY(“Sales Line”.“Shipment Date”,2);

from this i took the month as number. now i want to display the name…??

4

you can use FORMAT(Datevariable,0,’’).

5

FORMAT(“Sales Line”.“Shipment Date”,0,’’).This will return name of the month.

6

Hi Chamara if you got the correct answer please verify it.

7

Thanks a lot afroz…

Its workiing[Y]