i have been trying to solve it with the following New column on the fly,
if DayofMonth in (1,2,3,4,5,6,7,8,9) then put a 0 before, else leave as is.
obviously I'm trying to insert the 0 incorrectly. but wondering how?
nearly there
i have been trying to solve it with the following New column on the fly,
if DayofMonth in (1,2,3,4,5,6,7,8,9) then put a 0 before, else leave as is.
obviously I'm trying to insert the 0 incorrectly. but wondering how?
nearly there