Time Conversion🤔

NAJARINE

Hello Dear community 👋

In the ETL, how can i convert a date from this format for exemple : /Date(986083200000)/ to this format : 200104

Thank you in Advance 🙂

Bernhard Nöhreiter

Hi @NAJARINE ,

not sure what the origin of your number is but if it is the consecutive number that counts the days since 01.01.1900 (but in that case your number would be far too long) you can use year() and month () formulas in the ETL for conversion.

Regards,

Bernhard

Samson Sunny

Hi @NAJARINE,

I am not sure if this is what you are expecting, but you could try to directly replace the value in ETL or use an IF condition if there are multiple values that you want to replace.

Thanks,
Samson.

NAJARINE

Thank you very much @Samson Sunny and @Bernhard Nöhreiter