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 ...
Forum Discussion
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
------------------------------
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
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
------------------------------
"Month-Day-Year": "11-02-2021" or "08-09-2021"
------------------------------
Jack Woods | Low Code 4 Lyfe
------------------------------
- List("-",
PadLeft(ToText([Month #]),2,"0"),
PadLeft(ToText([Day #]),2,"0"),
[Month- Year#])
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
