Hello,
I am moving the data from an array to a table using this
The array dimensions have mixture of variable of sting, long, and date.
Where there are dates in the elements, the date-variables have the format of either d/mm/yyyy or dd/mm/yyyy.
If the array date is pushed into the table where the format is d/mm/yyyy the day becomes the month and the month becomes the day. eg array 4/06/2021 -> table 6/04/2021.
This is not a format issue, the array is 4th June 2021 and the table is 6th April 2021.
I have checked the cells/column date format and the date format is set as dd/mm/yyyy.
Ideas of how to fix?
I am moving the data from an array to a table using this
VBA Code:
tbl.DataBodyRange = Application.Transpose(arrTemp)
The array dimensions have mixture of variable of sting, long, and date.
Where there are dates in the elements, the date-variables have the format of either d/mm/yyyy or dd/mm/yyyy.
If the array date is pushed into the table where the format is d/mm/yyyy the day becomes the month and the month becomes the day. eg array 4/06/2021 -> table 6/04/2021.
This is not a format issue, the array is 4th June 2021 and the table is 6th April 2021.
I have checked the cells/column date format and the date format is set as dd/mm/yyyy.
Ideas of how to fix?