Time text format?


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!

Best Answers

  • SriNitya
    edited April 2 Answer ✓

    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
    Answer ✓

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


  • SriNitya
  • @enneagram test Last time we were looking to solve this problem, and today I found some instructions on the forum, please try reading and this afternoon we will continue the discussion

  • Kanishq17

    Hi , You can use the YEAR , MONTH , DAY functions to get the day , month and year from the date and then combine in one line item using TEXT() function