Hi Jul :)
It's not wise to save datevalues this way in your table, cos you will only be duplicating data and there is no way to check for inconstitencies. All you need to save is the "date" itself, then you can always use functions to call the datepart (year,month, weekending, etc) whenever you...