Sorry for the missunderstanding, I didn't meant the actual date.I send the values thruogh a form, I just dont know how would a normal date variiable would work if i write only 02-06 for example(02-month, 06-day) or 02/06 or 02.06 without defining the year.. And when it comes to query I would like to use simply somthing like this: select * from table where between month(12) and month(2)Is this correct? Would this give me the winter months? How should I do it? I would like to add records with date variables but without the year defined. Could somebody help me? Thanks for the fast reply though