Forum Discussion

JackWoods's avatar
JackWoods
Qrew Trainee
3 years ago

Date Formula Field

Hey Community, 

I'm looking to make a formula that combines My Numeric Date - Month - Year fields into one. Please see the screen grab attached. Let me now if you have any examples or the best way to do this.

Once this date field is set up - I need to do be able to match this date field to a standard "Date" formatted field so that I can build pipelines off of this and create resource allocations. Any information on that would be helpful.

Thank you,

------------------------------
Jack Woods | Low Code 4 Lyfe
------------------------------
Formulas and functions

4 Replies

Sort By
  • MarkShnier__You's avatar
    MarkShnier__You
    Qrew Champion
    3 years ago
    Can you give us an example of the result you are looking for based on the first line of the screen shot report?  Do you want th day and the month zero padded, for example?

    ------------------------------
    Mark Shnier (YQC)
    mark.shnier@gmail.com
    ------------------------------
    • JackWoods's avatar
      JackWoods
      Qrew Trainee
      3 years ago
      I thought about that right after I made the post lol. yes, I need it to be zero padded for single digit numbers. It also should be a dash (-) and NOT and slash (/). Examples below.

      "Month-Day-Year": "11-02-2021" or "08-09-2021"

      ------------------------------
      Jack Woods | Low Code 4 Lyfe
      ------------------------------
      • MarkShnier__You's avatar
        MarkShnier__You
        Qrew Champion
        3 years ago
        List("-",
        PadLeft(ToText([Month #]),2,"0"),
        PadLeft(ToText([Day #]),2,"0"),​
        [Month- Year#])

        ------------------------------
        Mark Shnier (YQC)
        mark.shnier@gmail.com
        ------------------------------
    • JackWoods's avatar
      JackWoods
      Qrew Trainee
      3 years ago
      That worked. Some minor changed to the format. I needed to add a ToText() to the year field 

      List("-",
      PadLeft(ToText([Month #]),2,"0"),
      PadLeft(ToText([Date #]),2,"0"),
      ToText([Month - Year #]))

      ------------------------------
      Jack Woods | Low Code 4 Lyfe
      ------------------------------