Time Conversion🤔

NAJARINE Active Partner
Level 200: Leveraging Board for Business Insights Level 100: Foundations of Building in Board Name Dropper First Comment

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 🙂

Accepted Answer

  • Bernhard Nöhreiter
    edited February 23 Answer ✓

    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.