0

Incorrect date format

We are try the approach of creating a text comma delimited file then importing into excel. I am having a problem in that all the schema fields are defined as string. I need to match our current output exactly – the problem is our current dates are outputted the csv file in this format

="08/11/1984".

I cannot get this to work using Adeptia – the combination of =” will not output. I tried various concat(s) but the only output that I could get to display was the = sign proceeding the value ex <Term_sp_Date>=01/19/1984</Term_sp_Date> cannot get = double quote to work

I cannot figure out the correct way to do this. Advice would be appreciated.

1 comment

Post is closed for comments.