Extract Date from String

[vardhancse]

Hi,

Have one requirement is that, Have 2 string columns

Need to derive date (DD/MM/YYYY hh:mm) format from those 2 columns .

Individually I tried to extract using Subfield and concatenate but the issue is with month I need to convert to number like for e.g Jan to 01 and similarly for all months

PFA sample app for reference.

[its_anandrjs]

This is also worked

Mid([Start Date],1,Len([Start Date])-3) as [Start Date]

Or

Mid([Start Date],1,Len([Start Date])-4) as [Start Date]

[vardhancse]

Fine thanks.

Could you please let me know how to convert to below format:

Output: DDMMYYYY

[vardhancse]

Thanks could you please let me know how to converted to only DDMMYY.

[Kushal_Chawda]

try this

date(floor(Timestamp#(mid([Start Date],1,Index([Start Date],'IST')-2),'MMM/DD/YYYY hh:mm:ss TT')),'DDMMYY')  as [Start Date]

[its_anandrjs]

This ways

Date(Date#([Start Date],'MMM/DD/YYYY hh:mm:ss TT'),'DDMMYYYY') as [Start Date New]

Or

Date(Timestamp#([Start Date],'MMM/DD/YYYY hh:mm:ss TT'),'DDMMYYYY') as [Start Date New]