Cancel
Showing results for 
Search instead for 
Did you mean: 

Datetime export

Pioneer
Pioneer

Hi everyone!

 

I have a table and I am using a column as string to input some datetimes values (I'm not using datetime  fomrat becouse the table I use to input uses "/" not ".")

 

1.JPG

But when i try to export this table to excel using the command "selectfileforsave" I dont know why but the excel is change values dd/mm/aaaa to mm/dd/aaaa (If check format is right dd/mm)

 

 2.JPG

 

The model setting im using is right.

3.JPG

Excel is the same as plant:

4.JPGI

 

By the configuration we can see that when I export dd/mm excel keep dd/mm but the values changes position dd/mm to mm/dd (but format dd/mm)

 

Regards

 

Arthur

 

2 REPLIES

Betreff: Datetime export

Gears Phenom Gears Phenom
Gears Phenom

Hi,

the Excel settings are only display/format settings and I think they do not matter when exporting data to Excel. If Plant Simulation uses the format with "." and your column is of type "string" with "/", then I don't know how/why Plant should be able to correctly export this as datetime. If you format the Excel column as "Text" before exporting the table, you will have the data exactly as in Plant Simulation (but it's no datetime then).

What I don't understand is why you don't use a "datetime" column in PlantSimulation, which is correctly exported to Excel. Also why do you use different datetime formats in PlantSimulation and Excel?

Best regards,
Alex

____________________________________________________________
Alex Dilg, Consultant at SimPlan AG (www.SimPlan.de)
This post was good and/or helpful to you? Please provide some Kudos, thank you!

Betreff: Datetime export

Pioneer
Pioneer

Hi Alex,

 

Actually I'm exporting from a software a big excel file (date time "/") then i'm using plant to do some filters and to separate 1 report in 5. Then i exports this 5 tables to a new excel file (here is the problem).

 

Maybe i should try to convert in the begining the string to date time in the correct form from plant. I will try it



Thanks.