Behavior of dates from an excel sheet

Userlevel 2
Badge +8

Question for the community: When you get data from an excel sheet and put it into a data table (no schema) using the get multiple cells (all) Excel command, if one of the columns is a date type in excel, what type of column do you get in the data table?

I’m getting mixed results when trying to read through the data table and place the data from a column into a date variable. I need to do some date formatting (US to European) and I need to detect when I’m receiving a European short date (d/m/yyyy) or a US date format (m/d/yyyy).

0 replies

Be the first to reply!