Date Datatypes

[lmit]

Hi All,

My Input file has data like

jun-2022

jun

18-jun-2022

is it possible to make my output as

1-jun-2022

1-jun-2022

18-jun-2022

If the above the out is not possible can i have get my output as

null

null

18-jun-2022

if the format is not correct it has to be null

The column datatype in input file is string

Can anyone suggest solution

Thanks in advance,

lmit

[Anonymous · Accepted solution]

Hi

You can call the built-in function TalendDate.isDate() to check the format on tMap and output different value based on the result.

TalendDate.isDate(row1.data, "dd-MMM-yyyy")?row1.data:null 

Regards

Shong

[lmit]

Thanks shong , it worked