Report Field - Formula Date and concatenate.
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 da...
Forum Discussion
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
------------------------------
------------------------------
Ahuva Brown
------------------------------
This worked, but i also had to convert the start and end dates to text. FOr anyone else that may need this in the future, i adjusted the type to formula - text and did the following:
If(
ToText([Project - Start Date])=ToText([Project - End Date]),NameOfMonth([Project - Start Date])&" "&Day([Project - Start Date])&", "&Year([Project - Start Date]),
Month([Project - Start Date])!=Month([Project - End Date]),NameOfMonth([Project - Start Date])&" "&Day([Project - Start Date])&" - "&NameOfMonth([Project - End Date])&" "&Day([Project - End Date])&", "&Year([Project - Start Date]),
NameOfMonth([Project - Start Date])&" "&Day([Project - Start Date])&" - "&Day([Project - End Date])&", "&Year([Project - Start Date]))
------------------------------
Ben Dellsperger
------------------------------
If(
ToText([Project - Start Date])=ToText([Project - End Date]),NameOfMonth([Project - Start Date])&" "&Day([Project - Start Date])&", "&Year([Project - Start Date]),
Month([Project - Start Date])!=Month([Project - End Date]),NameOfMonth([Project - Start Date])&" "&Day([Project - Start Date])&" - "&NameOfMonth([Project - End Date])&" "&Day([Project - End Date])&", "&Year([Project - Start Date]),
NameOfMonth([Project - Start Date])&" "&Day([Project - Start Date])&" - "&Day([Project - End Date])&", "&Year([Project - Start Date]))
------------------------------
Ben Dellsperger
------------------------------