Forum Discussion

dbryant4891's avatar
dbryant4891
Qrew Trainee
6 years ago

Convert Date Field to Text

I'm creating a Formula Date field called [Calculated Follow Up Date].  I've entered the following formula:

If(not Contains([Detailed Status], "Clinical Review In Process")
or not Contains([Detailed Status], "Cancelled")
or not Contains([Detailed Status], "Completed") and
IsNull(ToDate([F/U Detail])) and
[Records Request Status]="Requested",
[Maximum Records Request Date Sent] + Days(3),

There's more to the formula but the entry in bold is the only part that is giving me the error "expecting text but found date".  I've tried multiple type conversions but none will get the error to go away without.  Originally my [F/U Detail] field was giving me this error but I was able to get this corrected.

What am I doing wrong here!?  If it's needed, I've provided a screenshot and file attachment.


------------------------------
Danaya Bryant
Business Analyst
The van Halem Group
Atlanta GA
danaya@vanhalemgroup.com
------------------------------
Formulas and functions
  • DonLarson's avatar
    DonLarson
    Qrew Elite
    6 years ago
    Danaya,

    Your field is a Formula Text so you have to convert your data to text for the formula to be able to display it.

    Try substituting this

    ToText([Maximum Records Request Date Sent] + Days(3))

    This should add three days to the field  [Maximum Records Request Date Sent]  and then convert it to text .

    ------------------------------
    Don Larson
    Paasporter
    Westlake OH
    ------------------------------
    • dbryant4891's avatar
      dbryant4891
      Qrew Trainee
      6 years ago
      Hi Don,

      Thank you for responding!  That cleared it up.

      ------------------------------
      Danaya Bryant
      Business Analyst
      The van Halem Group
      Atlanta GA
      ------------------------------
      • AdamKeever1's avatar
        AdamKeever1
        Qrew Commander
        6 years ago
        You can switch the field type to formula date and use the ToDate() function (or remove the ToText() function) if you will need to use the calculated date in a calendar or timeline report Danaya.

        ------------------------------
        Adam Keever
        ------------------------------