Skip to main content
Question

Report Field - Formula Date and concatenate.

  • August 11, 2022
  • 0 replies
  • 120 views
I am working on a report that is used to build certificates for classes that we teach.  The report is exported and then used to mail merge in our certificates.

We teach classes that are either 1 day or multiple days / weeks.  In the 1 day class, we would like the certificate to just display the date that the class was taken.  In the case where the class spans multiple days, we would like the same field to show the extent of the class.

I have created a report that grabs all the necessary data for the merge, and have created a report field of type formula-date and am attempting to concatenate within the report. We are using start date and end date as with most projects, but attempting the following.

If([Project - Start Date]=[Project - End Date],[Project - Start Date],[Project - Start Date]&" - "&[Project - End Date]) 

As expected, i'm getting the dreaded "expecting date but found text" error.  Any advice on how to resolve this?

------------------------------
Ben 
------------------------------
    This topic has been closed for replies.

    • AhuvaBrown
    • Registered
    • August 11, 2022
    If you're attempting to concatenate two dates to display on your report, the report formula needs to be Formula-Text, not Formula-Date. You're getting that error because this: &" - "& is a function for text, not dates.

    ------------------------------
    Ahuva Brown
    ------------------------------
    Terms & ConditionsAccessibility statement