jimscott77

Data source changed date format

Discussion created by jimscott77 on Oct 21, 2015
Latest reply on Oct 23, 2015 by jimscott77

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..

 

DateEnding =

fmt1 '12/5/2014'

fmt2 '2014-12-05'

 

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

Outcomes