After merging CSV files date format changes to different format.

PrachiShah

When I am merging multiple CSV files into one file date format changes to a different format. I need all my dates in yyyy-MM-DD format. This problem started last Friday only I am using a sheet go for the past 6,7 months and it never happens before. What should I do?

Karoline from Sheetgo

PrachiShah Hi Prachi,

We’re aware of this change, and we’re working to release the fix ASAP.

While this does not happen, we do have a workaround:

Go to your source file and format the date as you want it to be
Then, on your destination file repeat the step above as well (just for one time)

After that, please run the connection again. The date should be in the chosen format.

Please, let me know if it worked.

PrachiShah

Hi Karoline
Thank you for your reply. I didn’t understand the workaround. What do you mean by running the connection again? I need to update the date format in 3,4 columns every day So I need an easy way. Right now I have to manually change the format in each column.
It will be helpful if you can send a video of the whole process.

Thank You
Prachi Shah

Karoline from Sheetgo

PrachiShah Hi Prachi,

The tech team released the fix today and you do not need to do this manually from now.

Could you please run a test and let me know if it works?

Best ;)

PrachiShah

Karoline from Sheetgo

No, It didn’t fix the problem. The date format is coming out still wrong. Also, When I click on RUN to merge My CSVs, it shows me an error today. I created 2 workflows, and both are showing me an error with some files.
Please check what is going on.

Karoline from Sheetgo

PrachiShah Could you please share your workflow with me?
Enter our web app, click on the workflow, and then on “share settings.” Add my email karoline@sheetgo.com, press ↹ (tab key), and make sure you enable “manager access” and check the "enable file editing"check box

Thank you!

PrachiShah

Hi
I am not able to merge my files since I reached my limits. Can you please unlock my account as per Vitor’s previous email? I also renewed my subscription.
Thank you

Karoline from Sheetgo

PrachiShah Hi Prachi, Did you run the workflows 125 and 126 again?

Chethan

Date format is mismatching when its is updated

Vitor from Sheetgo

Chethan Could you give us more details about what you are working on?

Here are a few things you can check to make sure the configuration is set up as it should:
- Have you checked the configuration on the source and destination spreadsheet to make sure they are both the same configuration?
- On the connection source have you checked the Date Format under advanced settings?
- Are you using the transfer formatting option? Have you read the documentation about it on this link?