Adding a yes/no field to a query

[linzeyd]

I have a table that has a bunch of dates in one column and I want to add a column via query to put a yes for everything > today's date and a no for everything < today's date. How do I do that?
Thanks!

[nico5038]

Best not to add such a column (will be different tomorrow :-)
We use a query for getting this information like:

select DateFieldX, IIF([DateFieldX>Date(),"Future","Past") as StateOfDate from tblX

Getting the idea?

Nic;o)

[NeoPa]

When you say you want to return Yes or No in your query, if these are simply the inbuilt Yes and No (rather than "Yes" & "No" strings), then the following concept will work for you :

SELECT [DateFieldX],
       ([DateFieldX]>Date()) AS [AfterToday]
 
FROM [tblX]

Otherwise, Nico's code gives a good template for your requirements, with the balancing closing square bracket (]) after DateFieldX in the IIF() function call (as in my doctored quote below).

select DateFieldX, IIF([DateFieldX]>Date(),"Future","Past") as StateOfDate from tblX