CODEWITHSUNDEEP
sqlms-access
MatthewEnderle
MatthewEnderle

Reputation: 119

Access query expression returns incorrect

I'm working on a query that pulls a date from another query, I have my reasons for the nesting. The problem I'm facing is that there is a field that is called DueDate.

My SQL is

SELECT DueDate 
FROM qryDueDates
WHERE DueDates <= DateAdd("d",60,Date())

The data causing the issue is when it equals something like "1/25/2019", "11/19/2019" or any date in 2019.

Goal

I need to limit the results to show dates that are expired or expiring within 60 days or less.

Results

I'm trying to prepare the dataset for the conditional formatting.

Report

Upvotes: 0

Views: 51

Answers (2)

MatthewEnderle
MatthewEnderle

Reputation: 119

Turns out that the original query was screwing it up. I moved the query into the main one and it worked.

Upvotes: 0

Rai
Rai

Reputation: 136

if you can put your nested sub-query in your post that may give better picture, and if you can mention what is the error you are getting that may also help. Since you mentioned that you are getting error only when sub-query returns certain dates, I would suggest that cast your sub-query result to DATE if you have not already done.

Below is my attempt to help you with limited information I could extract from your post. I have used some of MS-SQL function below, please replace with your DB specific function.

SELECT myDates.* FROM (select COLUMN_NAME DueDates from TABLE_NAME) as myDates WHERE myDates.DueDates <= DateAdd("d",60, GETDATE())

Upvotes: 0

Related Questions