CODEWITHSUNDEEP
simulationanylogic
Simran
Simran

Reputation: 3

Timesnaps change to string even when the simulation run time includes the date and time

I want to import arrival data using an excel sheetpart of the data in excel but the time snaps being in the valid format of date, still change to string in anylogic.

I have tried figuring out the actual format of the date format by creating a table in the database. The date format in DB table looks like db table while copying the same cell in the excel shows excel. I have checked the early query which got resolved because the simulation time was not in the range but I have included the dates according to the data imported. I want to know what format I should enter data in an excel sheet so that it is in the valid format of date type in AnyLogic. Please clarify how to import it such that it remains in the date format, as I have spent a lot of time figuring this out.

Upvotes: 0

Views: 61

Answers (1)

Benjamin
Benjamin

Reputation: 12793

This heavily depends on your Excel setup, language settings, locale...

Easiest way: Create a new AnyLogic dbase table with a date column manually, fill it with some dates manually and export it to a separate Excel file. Check the format it appears there and try to re-import it into a dbase table. Then, it should be recognized as a Date again.

(These date exercises are always tedious and 99% of the time it is an Excel issue)

Upvotes: 0

Related Questions