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

c# - Pausing a storyboard on TabItem mouse over -

erlang - Saving a digraph to mnesia is hindered because of its side-effects -

c# - How Configure Devart dotConnect for SQLite Code First? -