Aug 6, 2024
0
Level 1
Excel filter does not work in date format
Hi, I am using Laravel Excel to export data, specifically I have the column 'J' and 'K' with date format, for the date I am using the following format in the export:
public function columnFormats(): array{
return [
'J' => NumberFormat::FORMAT_DATE_DDMMYYYY,
'K' => NumberFormat::FORMAT_DATE_DDMMYYYY,
];
}
I do the export through a view and the code is as follows:
<td style="text-align: center;"> {{ \Carbon\Carbon::parse( $factura->FECHAEMISION )->format('d/m/Y'); }} </td>
<td style="text-align: center;"> {{ \Carbon\Carbon::parse( $factura->VENCIMIENTO )->format('d/m/Y'); }} </td>
he problem is in Excel, when I open the filter it appears as follows:

and the way I need the filtering is this:

Please or to participate in this conversation.