Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It only takes a minute to sign up.
Sign up to join this community
I'm trying to convert a text field to date and only pull back records that have a date of yesterday but getting zero records back. I've converted the text to date part but can't get the where clause working and not sure where I'm going wrong.
SQL Query:
SELECT
REQUEST_DATE,
convert(varchar, REQUEST_DATE ,101) as REQUEST_DATE1
FROM temp
Where convert(varchar, REQUEST_DATE ,101) > DATEADD(DAY,-1,getdate())
If you just want rows from yesterday, you can do something like this:
select
request_date,
convert(date, request_date) as request_date1
from temp
where convert(date, request_date) >= convert(date, getdate()-1)
and convert(date, request_date) < convert(date, getdate())
If your request_date is actually a date datatype in SFMC, then you can simplify it like this:
select
request_date
from temp
where request_date >= convert(date, getdate()-1)
and request_date < convert(date, getdate())
