Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
how to convert Num to text in for date ,i want to display in string for month.
=(max(month(dvdate))-1)
Hi,
try with this expression
=Date(Date#((max(month(dvdate))-1),'M'),'MMM')
or
=Date(Date#((max(month(dvdate))-1),'M'),'MMMM')
Hi,
try with this expression
=Date(Date#((max(month(dvdate))-1),'M'),'MMM')
or
=Date(Date#((max(month(dvdate))-1),'M'),'MMMM')