fetch days exactly 2 days ahead of set date for departure column

70
January 03, 2022, at 02:00 AM

how can I fetch and display data 2 days ahead of set date from the column 'departure' from table 'products'

for example say today is 31st December 2021 and I set 'departure' as 2022-01-05 of some products for 5th Jan 2022

so on the 3rd Jan 2022 I want to display only those data?

I tried this but get blank page though i have a record with departure date set as 2022-01-03

SELECT * FROM products WHERE DATE_FORMAT(departure, '%Y-%m-%d') = (NOW() - INTERVAL 2 DAY) ORDER BY id DESC
READ ALSO
Value in between javascript

Value in between javascript

I have an arrays of object,

99
Sorting dates by week and calculate sum using nodeJS

Sorting dates by week and calculate sum using nodeJS

I have a group of array values with 'Working_date' and 'Working_hours' as given belowThese dates can be any dates but most probably they will be consecutive dates

124
How to give map api key dynamically in android

How to give map api key dynamically in android

I have a use-case in my android app that users of my application has to give api key so that they can use the map

111
Required field validator for monaco editor

Required field validator for monaco editor

The following code sets the required field validation for text area and is working fine

56