Hvordan: Træk en dato (Date()) fra Feltet "NewsEndDate" ?

Kodestumpen jeg leder efter er alstå det som der skal stå i Default Value for DateDiffNews

You can NOT do this in Default Value!

Accepteret - men kan du fortælle mig hvordan jeg så får værdien af datediff-beregningen ind i fletet DateDiffNews?

chrilles> In Default Value you can use KNOWN values such as Date() Or Now() but you CAN NOT calculate a value from another field in the record becuase it is UNKNOWN! While you are entering data into a record the record DOES NOT exist yet and only when ALL (necessary) fields have been enetered is the record written to the table. So DateDiffNews doesnt know th evalue of DateEndNews UNTIL after the record has been written to the table. Hope you understanbd what I mean!

If you enter the data through  a form then this IS possible.

In the forms BEFORE UPDATE event add

Me.DateDiffNews  = DateDiff( Me.DateEndNews, Date())

Thanks a lot. I guess I need to enter the code in my ASP page in stead. Thanks a lot again for your detailid explanation and your fast answer. I understand now!

Little error there!
This gives you the diffrence in days! Try looking at HELP for other paramters!

Me.DateDiffNews  = DateDiff("d", Me.DateEndNews, Date())

Yes you can do it in ASP JUST before you write the data to the databases!