Hello,

We are running into a few issues with the date fields from 2 data sources.

DART and DATE
We are connecting to DART and have a DATE field. Based on the Field Organizer, the original format of the DATE comes in as Category. We want to convert this to use a Date/Time format (so that we can run some formulas later on), however, when choosing the Date/Time option in the drop down, it blanks out the entire date entry. I believe we've used this function before, so not sure why this is removing the date entries now.

How can we ensure that a date is read as a date?


SALESFORCE and DATE
We are connecting to Salesforce and also have a DATE field. Based on the Field Organizer, the original format of the DATE comes in as Date/Time. The date format is defined as yyyy-MM-dd and this is displaying properly in the preview. We want to concatenate this date with another column, however, when we do this, the date formatting is being converted to a very long string.

Ex. Start_Date= 2013-01-01
End_Date = 2013-01-31
Campaign_Name = XXX

Formula: [Campaign_Name]+ " ("+[Start_Date]+" - "+[End_Date]+")"

Result: XXXX (Tue Jan 01 00:00:00 EST 2013 - Thu Jan 31 00:00:00 EST 2013)

How can we keep it so that what we concatenate is the same as what is being displayed?



Please let me know if you need additional information to further investigate.

Thanks,
Catherine