I regularly import data from an outside data source(DS) in the form of a csv file. That DS changed how they displayed date formats from 'm/d/yyyy' (fmt1) to 'yyyy-mm-dd' (fmt2).
The data loads fine but the following calculation fails to work with fmt2 but does work with fmt1..
rptDate with fmt1= If(IsEmpty(DateEnding);"Active";MonthName(DateEnding) & ", " & Year(DateEnding)) = "December, 2014"
rptDate with fmt2= If(IsEmpty(DateEnding);"Active";MonthName(DateEnding) & ", " & Year(DateEnding)) = "?, ?"
- DateEnding is a date field
- rptDate is how I want the information to show on my report(s)
- if DateEnding is empty I want the word "Active" to appear on the report.
Is there a way to use both date formats at the same time