I would like to convert the following date to YYYYMM but am struggling to find the right format:
I have searched on the community but have not come across the right example. Has anyone converted this type of timestamp yet?
Solved! Go to Solution.
I would suggest using MonthStart or MonthEnd because if you don't then may be you still see YYYYMM, it would still show up as multiple entries in list box or straight table because the date can still be different. With MonthStart we will essentially making all the dates within that month equal to 1.