Convert a date from a TEXT formula to quarter

Options
Burubear
Burubear Member, ALL USERS Posts: 3 Occasional Contributor
in Planning & Modeling

Hi there,

 

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.

 

 

Tagged:

Comments

  • Burubear
    Burubear Member, ALL USERS Posts: 3 Occasional Contributor

    Hi David,

     

    date1 and date2 as text because they are imported. If I just change the format to DATE, I'll lose the data. What is the best way to convert them into DATE?

     

    I tried to follow your suggestion by creating the Sales Type List as well as the Sales Type Details module. Is this formula for the "Renewal Date"? Are the Date1 and Date2 from my module which stores these two dates? However, it still gives me an error as Date1 and Date2 are TEXT.

    IF Sales Type Details.Date1? THEN PERIOD(Date1) ELSE PERIOD(Date2)

     

    Please further explain. Thanks.

     

     

  • Burubear
    Burubear Member, ALL USERS Posts: 3 Occasional Contributor

    I have already have the calculated date1 or date2 under the "Renewal Date" as I showed earlier. It goes back to my original question is how can I convert the TEXT into DATE.

    If the renewal date is 12/31/2018, what is the right formula to convert this TEXT into Date when I create a new item?

     

    Thanks. 

Categories