topic I require this date format Thrusday,January 20,2022 to DD/MM/YYYY in App Development

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

Sai-Nirant — Tue, 06 Feb 2024 12:01:00 GMT

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

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

LRuCelver — Tue, 06 Feb 2024 12:33:55 GMT

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" ];

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

Anil_Babu_Samineni — Tue, 06 Feb 2024 12:53:04 GMT

@Sai-Nirant Perhaps like this way.

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

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

Sai-Nirant — Wed, 07 Feb 2024 02:41:22 GMT

Its working thank you so much Clever.

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

Sai-Nirant — Wed, 07 Feb 2024 02:42:33 GMT

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

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

Nagaraju_KCS — Wed, 07 Feb 2024 04:53:22 GMT

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"
];

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

vinieme12 — Wed, 07 Feb 2024 06:57:07 GMT

you can do this in one pass

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