Retrieve month name from date.

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…??


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


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…??

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

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

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

Thanks a lot afroz…

Its workiing[Y]