Time Conversion🤔

NAJARINE · 2024-02-22T16:37:49+00:00

There was an error rendering this rich post.

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 🙂

Find more posts tagged with

Accepted answers

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

All comments

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.

Bernhard Nöhreiter

Hi @NAJARINE ,

Regards,

Bernhard

NAJARINE

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