Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAOne tool solution
Below is the solution for the above challenge in which I have created a formula for changing the date field in the above specified challenge the formula for which is given below.
IF
tonumber(right([Date],findstring([Date],"/"))) < 4 then "Q1 "
elseif
tonumber(right([Date],findstring([Date],"/"))) < 7 then "Q2 "
elseif
tonumber(right([Date],findstring([Date],"/"))) < 10 then "Q3 "
else "Q4 "
endif