how to convert Num to text in for date ,i want to display in string for month.

[venkat1]

how to convert Num to text in for date ,i want to display in string for month.

=(max(month(dvdate))-1)

[StarinieriG · Accepted solution]

Hi,

try with this expression

=Date(Date#((max(month(dvdate))-1),'M'),'MMM')

or 

=Date(Date#((max(month(dvdate))-1),'M'),'MMMM')