Set number date to text date with Crystal report.

 

local stringvar From_Day;
local stringvar To_Day;
local stringvar MMM;
local stringvar YYYY;

From_Day := totext(day(pwformatdate(tonumber("20211101"))),00);
To_Day := totext(day(pwformatdate(tonumber("20211116"))),00);;
MMM := totext(pwformatdate(tonumber("20211116")),"MMM");;
YYYY := totext(pwformatdate(tonumber("20211116")),"yyyy");;

UCASE(MMM) + " " + totext(tonumber(From_Day),"00") +"-"+ totext(tonumber(To_Day),"00") + ", " & YYYY;

 

You May Also Like

Leave a Reply

Your email address will not be published. Required fields are marked *