error in code when changing from date and time to seconds

Question

question

Kevin S7 asked Oct 24, '23 Jason Lightfoot commented Nov 3, '23

error in code when changing from date and time to seconds

Greetings community I have a problem when importing an Excel I have a date and time and I want to convert those Excel input data to seconds in my global table but it gives me very high values which should not be, what could be wrong in my code? import source

The times must go to seconds regardless of when the simulation starts running and be able to change the start date and time of the simulation.

code of import

int onreset = param(1); //1 if this code is being called on Reset of the model, 0 otherwise

Table table = Table(Model.find("llegadas (Global Table"));

DateTime ModelStart = Model.dateTime; //get model start time as a number

for (int i = 1; i <= table.numRows; i++){

string StartTime = table[i][1];

DateTime date = DateTime(StartTime, "%m/%d/%Y "); //get string as a number

table[i][1] = date - ModelStart;//calculate the difference between start time and arrival time in number of seconds

}

timw.fsm

Software Version:

FlexSim 23.2.1

time table

1698158740317.png (102.8 KiB)

timw.fsm (56.0 KiB)

· 4

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Jordan Johnson ♦♦ commented · Oct 24, 2023 at 09:22 PM

Can you post your Excel file as well?

0 ·

Kevin S7 Jordan Johnson ♦♦ commented · Oct 24, 2023 at 09:27 PM

Datostim2.xlsx

0 ·

datatim2.xlsx (9.2 KiB)

Kevin S7 Jordan Johnson ♦♦ commented · Oct 24, 2023 at 09:30 PM

@Jordan Johnson Greetings, I just uploaded my file. I just wanted you to help me correct the code. I don't know what's wrong to import the date and time into seconds and for the time to adapt to the start time.

0 ·

Jason Lightfoot ♦♦ commented · Nov 03, 2023 at 11:05 AM

Hi @Kevin S7, was Jordan Johnson's answer helpful? If so, please click the "Accept" button at the bottom of their answer. Or if you still have questions, add a comment and we'll continue the conversation.

If we haven't heard back from you within 3 business days we'll auto-accept an answer, but you can always comment back to reopen your question.

0 ·

Answer 1 · 2023-10-24T21:49:14Z

Jordan Johnson answered Oct 24, '23 Jason Lightfoot commented Oct 30, '23

In Excel, Dates and Times often look like text, but they are usually stored as numbers. If I import your excel data without changing anything, I get the following data:

Notice that all the date values are around 45000. Excel date/times are stored as the number of days since 1900.

FlexSim DateTime objects, on the other hand, count the number of seconds since 1601 (or maybe 1600, I can't recall).

So, knowing this, it is incorrect to try to use the text of the Excel data. Instead, you can use the number. To convert between Excel time and FlexSim time, you can use the convert() command:

DateTime date = DateTime(convert(StartTime, XL_DATETIME, FS_DATETIME));

But there are other problems as well:

The global table "llegadas" has a space after the name. It is best not to use trailing whitespace like that.
To access a global table, you just need the following syntax:
```
Table table = Table("llegadas");
```
To access the start time as a date time, use
```
Model.startDateTime
```

Those are all the issues I've found so far. See if you can get somewhere making those changes. Best of luck!

1698183417193.png (11.5 KiB)

· 9

5 |100000

Attachments: Up to 12 attachments (including images) can be used with a maximum of 23.8 MiB each and 47.7 MiB total.

Kevin S7 commented · Oct 24, 2023 at 10:00 PM

@Jordan Johnson I enter the lines of code that you provided in the imported code section and I get an error

0 ·

1698184799991.png (5.0 KiB)

Felix Möhlmann Kevin S7 commented · Oct 25, 2023 at 08:39 AM

When you click "cancel" the compiler should show you where the error is in the code plus a brief description of what is wrong. (The error can be in a previous line, like a missing semicolon or parentheses, but generally you should be able to spot the mistake quite quickly with that information.)

The code Jordan provided should work though.

Table table = Table(tableName);  // placeholder name
DateTime ModelStart = Model.dateTime; //get model start time as a number
for (int i = 1; i <= table.numRows; i++)
{
    double StartTime = table[i][1];
    DateTime date = DateTime(convert(StartTime, XL_DATETIME, FS_DATETIME));
    table[i][1] = date - ModelStart;
}

0 ·

Kevin S7 Felix Möhlmann commented · Oct 25, 2023 at 12:59 PM

@Felix Möhlmann Greetings I just entered the code in the import code part but it doesn't work, it should give me in seconds and it gives me a very high value which is not

code1.fsm

0 ·

1698238766521.png (119.9 KiB)

code1.fsm (55.9 KiB)

Show more comments

question