Hi community,
we have the below (screenshot) calendar identifier in AIMMS and are writing data indexed over iWeek (elements of the form "w44-2024") to Parquet files using DEX. Now, whenever DEX does this for us, these elements are written to the Parquet file as "2024-10-28 01:00:00" instead, looking like a datetime object being the first time instant of this week. Similarly, for months, a datetime object is written being the first time instant of this month. However, when reading in these Parquet files again using DEX, with the same mapping, these month elements are read in correctly while the week elements are not. I.e., the element "2024-10-28 01:00:00" above cannot be mapped back again to "w44-2024".
We would be interested to hear any best practices regarding reading and writing calendar elements using DEX and if we are overlooking something here.
Thanks!