Concatenation of dates

[Mark4]

I have an excel spreadsheet with 3 individual dates in three separate columns: Budget Date, Forecast Date, Execution Date.  

If one exists, the others are null.

I need to concatenate these three date fields in the load editor then run the [autoCalendar] script breaking them out into quarters, years, etc...

Running the script as-is I get three dates with the autocalendar, I need them to be combined into one so my pivot table will work properly.

Thank you for the help.

[CELAMBARASAN · Accepted solution]

Create a new Date column by using Alt

Date(Alt([Budget Date], [Forecast Date], [Execution Date])) as CalendarDate

Thanks

Celambarasan