ms access - Date function in SQL? -


i'm using access database , need write sql queries display information. can't figure out how display need.

in english, need query display description expiration date when expiration date less thirty days current date.

my knowledge of sql limited. if point me specific resources helpful. in advance.

here have:

select description, [expiration date] hardware [expiration date] = "(get date()"; 

you can use functions now() , date() current date.

to add days date, use dateadd function.

where dateadd(d, 30, [expiration date]) >= date() 

Comments

Popular posts from this blog

mongodb - Struggling to get ordered results from the last retrieved article, given array of elements to search in -

c# - Pausing a storyboard on TabItem mouse over -

c# - Attribute value in root node of xml Linq to XML -