Modifying dates

[Lou_Reed]

I am interested in using some date queries and I need some guidance. It seems that one must put in criteria
such as 12/1/2016 and 6/10/2016.

Now I am interested in finding a equivalent for the present data. That could be 5/19/2016 or it could be something else.

Please note that the present day will not 5/19/2016 it will be 5/20/2016. That means it is, of course, always changing.

So instead of putting in an actual date is there some other way that I can represent the present.

Any help appreciated. Thanks in advance.



Respectfully


Lou_Reed

[John_G]

Use the Date() function to represent the current date.

The format of the returned string is affected by your regional settings (set in Control Panel); on my PC for example the Date() function yields 19/05/2016.

[Lou_Reed]

Yes, that seems to work. Thank you very much.

Respectfully,

Lou_Reed

[Lou_Reed]

Can I use Date(0) and date(0)-n or Date(0)+n in queries?

Respectfully,

Lou_Reed

[Lou_Reed]

I have a list of personnel for one column and a column of dates beside the name such 06/30/2016. This indicates the date of expiration of a license or permit that they each have.

Now what I want to create an additional list with the word expired (when the date fall before the Date(0) or current when the date falls after the Date() and then expiring soon when the date is current but falls within
three of the expiration date.


However, I want to say. "expired", "current" or "expiring" soon. I am not sure how to do that. I mean I can figure out the queries for each category, but to get it to actually say "expired" or whatever is another matter.

Any help appreciated. Thanks in advance.

Respectfully,


Lou Reed

[John_G]

Can I use Date(0) and date(0)-n or Date(0)+n in queries?

No. Putting any parameter at all in the Date function will generate an error.

Use the DateAdd function to add or subtract values from dates.