I have two fields, one is MM/DD and the other is YYYY. I want to combine both into one with the end result being YYYY-MM-YY. Thank you so much
Solved! Go to Solution.
suppose field1 is mm/dd (example: 11/22) and field2 is yyyy (example 2017)
[Field2] + "-" + Replace([Field1],"/",'-')
That's the answer (I hope).
Cheers,
Mark