I'm using the Laravel Excel library and so far I've been fine with many different file formats, etc... The thing is, now I have the following case:
In the excel file they pass me a date in dd/mm/yyyy format and without treating it or anything I do a dd($sheet->toArray()); of all the content of the file and it tells me that the date is 01-01-1900, very strange, does anyone know what that is due to? Or how can I do to indicate a default format? Or that I just get that value as a string instead of Carbon ??
CAPTURE:
In the end I have seen that unlike other sites where I used the function I have noticed that in this case I was using two global variables and in the other cases only one.
I have removed it for a moment and I have tried to load it and the date was fine, I have left everything as it was and it has worked for me... Very curious.
I have removed the $account variable from within the use and without further ado it wanted to work.