Skip to main content
Question

Convert Date Field to Text

  • February 17, 2020
  • 0 replies
  • 85 views
Forum|alt.badge.img+5
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
------------------------------
This topic has been closed for replies.

Forum|alt.badge.img+15
  • DonLarson
  • Quickbase Alumni
  • February 17, 2020
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
------------------------------
Terms & ConditionsAccessibility statement