Forum Discussion

globus1987's avatar
globus1987
Occasional Contributor
13 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
    13 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
13 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
    5 years ago

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