I require this date format Thrusday,January 20,2022 to DD/MM/YYYY

[Sai-Nirant]

Date
Thrusday,January 20,2022
Monday,April 02,2022
Saturday,June 10,2023
Friday,July 15,2021
Sunday,December 18,2022
Tuesday,October 21,2021

[LRuCelver]

Data:
NoConcatenate Load
	Date(MakeDate(Year, Month, Day), 'DD/MM/YYYY') as Date;
Load
	Year,
    Num(Month(Date#(Left(SubField(MonthDay, ' ', 1), 3), 'MMM'))) as Month,
	Num(SubField(MonthDay, ' ', 2)) as Day;
Load
	SubField(Date, ',', 2) as MonthDay,
    Num(SubField(Date, ',', 3)) as Year
Inline [
    Date
    "Thursday,January 20,2022"
    "Monday,April 02,2022"
    "Saturday,June 10,2023"
    "Friday,July 15,2021"
    "Sunday,December 18,2022"
    "Tuesday,October 21,2021"
];

[Anil_Babu_Samineni]

@Sai-Nirant  Perhaps like this way.

=Date(Date#(DateFormat, 'WWWW,MMMM DD, YYYY'), 'DD/MM/YYYY')

[Sai-Nirant]

Its working thank you so much Clever.

[Sai-Nirant]

I already tried this way but it's not working. Anyway, thanks for your reply, Anil.

[qv_testing]

Try this..

LOAD *, Date(Date#(Date1,'MMMM DD,YYYY'),'MM/DD/YYYY') as [Require Date];
LOAD *, SubField(Date, 'y,', 2) as Date1;
LOAD * inline [
Date
"Thrusday,January 20,2022"
"Monday,April 02,2022"
"Saturday,June 10,2023"
"Friday,July 15,2021"
"Sunday,December 18,2022"
"Tuesday,October 21,2021"
];

[vinieme12]

you can do this in one pass

date(Date#(subfield(Date,',',2)&subfield(Date,',',3),'MMMM DDYYYY'),'DD/MM/YYYY') as FormattedDate