Hi,
I am trying to write a trigger, whereby it gets todays date, which is pretty easy, but I also want the date of the monday of that week...
So if I inserted some thing tomorrow I want the date in the date column as 6/12/04, and a weekstarted column with 5/12/04... I have no idea how to go about this, as I am a trigger virgin!
Hope someone can help.
Jamie
I am trying to write a trigger, whereby it gets todays date, which is pretty easy, but I also want the date of the monday of that week...
So if I inserted some thing tomorrow I want the date in the date column as 6/12/04, and a weekstarted column with 5/12/04... I have no idea how to go about this, as I am a trigger virgin!
Hope someone can help.
Jamie