Time text format?

Options
EXART
EXART
in Modeling

Hello everyone,

I hope you are all doing well.

I am writing today to inquire about the best formula to transform text from the format DD/MM/YYYY to DDMMYYYY.

For example: 02/04/2024 should be transformed to 02042024.

Thank you!

Tagged:

Best Answers

  • SriNitya
    SriNitya
    edited April 2 Answer ✓
    Options

    ILYAS
    Hi
    The transformation from text 02/04/2024 to 02042024 text can be done.
    By using FIND,LEFT, MID,RIGHT functions fetch DD,MM,YYYY and then concatenate.
    From text to date format it cannot be done.

  • Dikshant
    Dikshant
    Answer ✓
    Options

    Sharing the formulas, and this will work with any separator. Just update the separator line item.

    image.png
    image.png

Answers

Categories