Wrong date format exporting

1

Hi,
I am using these nodes to export the date in a specific format. However, in the excel cell the date is reversed.

image
image1333Ă—460 37.3 KB

image

Why is the date reversed?

2

Hello @JC.Moreno …think the dateformat is controlled by windows

3

Thank you @sovitek. I solved the problem.

4

Great how ?

5

I used a python script node to reverse the date. It is not a greate but it works for the moment

import datetime

# get the current date
current_date = datetime.datetime.now().date()

# convert the date to a string in yyyy-MM-dd format
formatted_date = current_date.strftime('%Y-%m-%d')

# output the formatted date
OUT = formatted_date
7

Hi,

As @sovitek mentioned you could also check the settings in windows by going to:

  1. go to Control Panel > Click on Clock and Region and then select Region
  2. Inside the Region dialog click on Additional settings…

image
image557Ă—710 17.2 KB

image
image530Ă—790 18.3 KB

8

Hi,
Yes I have this in my case:
image
j = jour = day
M = mois = month
a = année = year

9

Have you confirmed that the particular cell you’re looking at in Excel is formatted the same? This seems more like an Excel issue, especially since Excel will auto-format anything that looks like a date.

10

I have this format in excel
image

11

It’s probably an issue with Excel auto-formatting then. Since the value you’re sending to Excel is just a string (not a formatted date) Excel is probably assuming a format of MM-dd-yy and converting that to dd-MM-yy. I think your current workaround of changing the initial format is your best bet. You essentially need to make sure that the format you’re providing Excel has no way of being misinterpreted (if you’re going to use Excel formatting) or that you force the Excel document to use no formatting at all (string and/or number only).