Proper syntax for date between where clause

lintu98

Hello Folks,

I need some help with the proper syntax to use on the server-side.

I have the following where clause -
WHERE table_date_column BETWEEN '2019-01-01' and '2019-12-31';

For which, on the data processing side, I added the following code which is not working -
$q->where( 'table_date_column', 'between '2019-01-01' and '2019-12-31'');

Could someone let me know what the correct syntax should be?

Thank you.

rf1234

$q ->where( function ( $r ) {
    $r ->where( 'table_date_column', '2019-01-01', '>=' );
    $r ->where( 'table_date_column', '2019-12-31', '<=' );
} );

lintu98

Thank you @rf1234 for your assistance.