Forum Discussion

globus1987's avatar
globus1987
Occasional Contributor
14 years ago
Solved

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. Wh...
  • Virgin_Australi_1's avatar
    Virgin_Australi_1
    14 years ago
    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.
Virgin_Australi_1's avatar
Virgin_Australi_1
New Contributor
14 years ago
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.
Ahmedsaoud's avatar
Ahmedsaoud
Visitor
7 years ago

This is a fantastic reply thank you for this formula finally my sheet run perfect