Convert a date from a TEXT formula to quarter
I would like to create two new items for calculating “Renewal Date” and “Renewal Qtr”. I am able to figure out the calculation of “Renewal Date” but not the “Renewal Date” into quarter.
Sales Type (Format: TEXT)
Date 1(Format: TEXT)
Date 2(Format: TEXT)
The formula of “Renewal Date” is:
IF Sales Type = "Electronic" THEN Date 1 ELSE Date 2 (Format: TEXT)
I can’t use Period (Renewal Date) as it gives me an error that “Renewal Date” is TEXT but not a DATE. How can I convert it into quarter? Thanks.