Hi…
I figured out that +thisRow.[Enter date].format("{1:00}/{2:00}", Day(thisRow.[Enter date]), Month(thisRow.[Enter date])) would give me 05/20 but if I try to add year I get an unexpected result:
Just wondering if there is a way to alter your formula to get just the last two digits of the year (22)?
I am always trying to learn…so it’s interesting to me that two different formulas give similar results.
Your formula with field.Day() etc gave very similar results to my formula with field.format("{1:00}/{2:00}/{3:00},(Day(field), Month(field), etc
Your formula is very tidy, mine was messy. But why did both give the same result for Day and Month but my formula didn’t give the right result for Year?