Skip to main content
Question

extracting parts of text for the purposes of new date fields

  • October 16, 2023
  • 0 replies
  • 68 views
Forum|alt.badge.img+5

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

    This topic has been closed for replies.

    MarkShnierYou
    Forum|alt.badge.img+24

    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
    ------------------------------
    Mark Shnier. Your Quickbase Coach
      Terms & ConditionsAccessibility statement