date formats

[Dolly123]

we have to change date formats to dd/mm/yyyy formats

[MayilVahanan]

Hi

This is one of the methods to achieve your expectation.

MapValue:
Mapping
Load * Inline
[
Value, ReplaceValue
st,
nd,
rd,
th,
];
Load *, Date(Date#(MapSubString('MapValue',Date), 'D MMM YYYY'), 'DD/MM/YYYY') as Date1 Inline
[
Date
1st Apr 2023
2nd Apr 2023
3rd Apr 2023
4th Apr 2023
];

[_Iswarya_ · Accepted solution]

You can try like this:

=Date(Date#(KeepChar(SubField(Order_Date,' ',1),'1234567890')&' '&SubField(Order_Date,' ',2)&' '&SubField(Order_Date,' ',3),'D MMM YYYY'),'DD/MM/YYYY')