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.
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.

2 Replies

  • 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

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