Forum Discussion

QuickBaseAdmi10's avatar
QuickBaseAdmi10
Qrew Member
7 months ago

extracting parts of text for the purposes of new date fields

Hello,

I have a field that imports in the following manner every single time with no variation to the format:

20230731-20230814

My question is, how do I split this up into:

[Date one]  = 20230731

[Date two]  = 20230814

These would also be recognized as dates by QuickBase

Thank you in advance



------------------------------
QuickBase Administrator2
------------------------------

2 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    7 months ago

    I suggest this approach although I'm traveling now and can't write out the whole formula for you.  You will need the Mid function similar to Excel to parse out the text into their respective YYYY MM DD and then use the Date(YYYY,MM,DD) function to make a date field.

    Date(

    ToNumber(Mid([My Field], 1, 4)),

    ToNumber(Mid([My Field], 5, 2)),

    ToNumber(Mid([My Field], 7, 2)))

    then similar for the next date field but stating off at position 10



    ------------------------------
    Mark Shnier (Your Quickbase Coach)
    mark.shnier@gmail.com
    ------------------------------
    • QuickBaseAdmi10's avatar
      QuickBaseAdmi10
      Qrew Member
      7 months ago

      Worked perfectly!

      Thank you



      ------------------------------
      QuickBase Administrator2
      ------------------------------