Date format & Excel DataSource
Hi,
I use datasource with excel file as source.
I use formulas there to calculate date with format YYYY-MM-DD
When I use datasource it changes to dd.mm.yyyy.
It's not valid for my web service.
What can I do to change it.
It's one value from a set of data.
I use datasource with excel file as source.
I use formulas there to calculate date with format YYYY-MM-DD
When I use datasource it changes to dd.mm.yyyy.
It's not valid for my web service.
What can I do to change it.
It's one value from a set of data.
- I had the same issue not long ago. You need to convert to TEXT in Excel.
Create new column and add:
=TEXT(CI3,"yyyy-mm-dd")
Where CI3 is the original date cell.
I'm not sure, but I also think you might be able to just put a ' before the date and it could work.
