Excel Export with Date Format

Just format the date as you need. https://www.w3schools.com/php/func_date_date_format.asp

Or use carbon.

@jlrdw Thanks for your reply.. I already tried this method, It is giving error when I add the date format in the below code.

 return Account::select(['th_tran_no','created_at','th_supp_name','th_bill_dt','th_bill_no','th_bill_amt','th_purpose','th_emp_name'])
       ->where('th_comp_code', auth()->user()->company)->where('th_pay_status', 0)
       ->get();

@bhhuassain, Can you include the code where you are formatting the date and also the error you are getting?

If you want to format your column, you can implement the WithColumnFormatting interface and write a columnFormats() method that returns an array:

Please see: https://docs.laravel-excel.com/3.1/exports/column-formatting.html

Mysql also has date formatting: I.e.,

part of query .....  DATE_FORMAT( `transactions`.`TransactionDate`, '%m/%d/%Y' ) `tdate`,  .....more query

You should lookup more on date formatting. https://dev.mysql.com/doc/refman/8.0/en/date-and-time-functions.html#function_date-format

@jlrdw Thank you very much for your reply.

part of query .....  DATE_FORMAT( `transactions`.`TransactionDate`, '%m/%d/%Y' ) `tdate`,  .....more query

This code is working in phpmyadmin but when I use the below code in laravel it is showing the below error

return Account::select(['th_tran_no',DATE_FORMAT( `th_bill_dt`, '%d/%m/%Y' ),'th_supp_name','created_at','th_bill_no','th_bill_amt','th_purpose','th_emp_name'])
       ->where('th_comp_code', auth()->user()->company)->where('th_pay_status', 0)
       ->get();

ErrorException
date_format() expects parameter 1 to be DateTimeInterface, null given

@glenuk Thank you very much for your reply.

When I use the format I am getting the below error message

Symfony\Component\Debug\Exception\FatalErrorException
Class App\Exports\AccountExport contains 1 abstract method and must therefore be declared abstract or implement the remaining methods (Maatwebsite\Excel\Concerns\WithMapping::map)

@bhhuassain

Looking at the error, I believe you are implementing the WithMapping interface

class AccountExport implements WithMapping

If this is the case, you will need to write the method that the WithMapping interface dictates; such as this example from the docs:

{    
    /**
    * @var Invoice $invoice
    */
    public function map($invoice): array
    {
        return [
            $invoice->invoice_number,
            $invoice->user->name,
            Date::dateTimeToExcel($invoice->created_at),
        ];
    }
}

See: https://docs.laravel-excel.com/3.1/exports/mapping.html

If this does not resolve your issue, please repost your entire class with your error.

@bhhuassain you were getting the error because in the select query if you want to add SQL function then you have to wrap it with DB::raw e.g:

   return Account::select(['th_tran_no',DB::raw( DATE_FORMAT( `th_bill_dt`, '%d/%m/%Y' ) as 									 
   date),'th_supp_name','created_at','th_bill_no','th_bill_amt','th_purpose','th_emp_name'])
   ->where('th_comp_code', auth()->user()->company)->where('th_pay_status', 0)
   ->get();