working with dates in SQL
Hi guys, looking for help with a problem with a small database I am setting up.
My dbase has only 2 tables which are
Employee ID (primary key)
NPK (foreign Key)
UKCC Table -
NPK (primary key)
UKCC expiry date
No Of day worked
PD review date
Now the problem I have is when creating a query to 'flag up' expiry dates 30 day before it does expire. I have no problems in cretaing the SELECT statement or FROM statement (as is always the case), and most of the WHERE statement i.e. linking the tables.
I know I cannot just subtract a integer from the expiry date, this is where I am struggling.
Any help would be greatly appreciated.
SQL Server? Take a look at the DATEDIFF function mate...
By David Croft in forum Database
Last Post: 08-13-2003, 01:45 PM
By Eric Litwin in forum VB Classic
Last Post: 09-24-2002, 11:13 AM
By James Lewis in forum VB Classic
Last Post: 04-02-2001, 07:44 AM
By francois in forum VB Classic
Last Post: 12-06-2000, 08:56 PM
By Devaraj in forum Enterprise
Last Post: 05-11-2000, 01:48 PM
-- Android Development Center
-- Cloud Development Project Center
-- HTML5 Development Center
-- Windows Mobile Development Center