Re: Campaigns retrieve status for specific day "2023-05-01"

2023-06-06 Thread maxcode ITSolutions
I am facing the same issue. On Tuesday, June 6, 2023 at 12:15:24 PM UTC+5:30 Jakub Banik wrote: > SELECT segments.date, campaign.name, campaign.id, campaign.status FROM > campaign WHERE segments.date BETWEEN '2023-04-01' AND '2023-04-01' ORDER BY > segments.date, campaign.name > This query abov

Campaigns retrieve status for specific day "2023-05-01"

2023-06-05 Thread Jakub Banik
SELECT segments.date, campaign.name, campaign.id, campaign.status FROM campaign WHERE segments.date BETWEEN '2023-04-01' AND '2023-04-01' ORDER BY segments.date, campaign.name This query above returns 0. SELECT campaign.name, campaign.id, campaign.status FROM campaign WHERE segments.date BETWE