Date in NPrinting Pixel perfect report

[vanand3535]

Hi all,

I want to display current or today date in pixel perfect report in NPrinting.

As of now I'm using the formulae to display the date is:-

=text(date(today(),'DD MMM YYYY'))

output :-  07 Jun 2018   (JUNE is showing only Jun )

But I want the output  :-

07 JUNE or June 2018

So, How can I do this?

[Chanty4u · Accepted solution]

try this

\

=text(date(today(),'DD MMMM YYYY'))

[Chanty4u]

for June 2018  try below

=text(date(today(),' MMMM YYYY'))

[vanand3535]

thanks it is working..

I'm getting output now:-

[Chanty4u]

great   have a nice day