Udregning af dage i databasen

Use dateadd function
In a query it would look like this

SELECT tbldato.*, tbldato.dato
FROM tbldato
WHERE (((tbldato.dato)>=DateDiff("m",6,Date())));

this shows you all those which were created 6 months or more ago!

Short date format only means how the date is displayed, it is stored in the database as any other date!

Or just to show the "tilmeld dato" and "udmeldelses dato"

SELECT tbldato.*, DateAdd("m",6,Date()) AS udm.
FROM tbldato;

Din kort datoformat skal stå i tabel. kør så en forespørgsel, men det er bedre at kører en sletteforespørgsel, så står m/k der ikke længere. Hvis du sætter den til 182 dage overtræder du ikke 6 mdrs reglen. I tabelen skal der stå udfor STANDARDVÆRDI Date() så skriver den automatisk datoen for oprettelsen. Hvis det er aktuelt så skriv om du vil kører den som Forespørgsel eller Sletteforespørgsel.

actually my first answer was WAY OFF

SELECT tbldato.*
FROM tbldato WHERE DateAdd("m",6,Date()) >= tbldato.dato ;

Its getting late :o)

182 days! which six months are we talking about? what i swrong in just adding 6 MONTHS to the original date, or is that too easy?

Jeg har prøvet at ligge 6 md. til indmelde dato. det virkede ikke og hvad så med årskifte. Skal jeg evt. have en kalender inbygget i databasen?

gvj> The dateAdd function WILL add 6 months to your date AND it will also take into account the following year.
If YOU are quick you can send the dB to terry@santhell.dk and I will take a look. Off to bed VERY soon!

If you send the dB then please ZIP it or rename it to .txt or Windows XP will ignore the file (throw it away)!

My SELECT form 21:33 DOES work! You obviously need to change the table and field names. Another idea is to cut and paste DateAdd("m",6,Date()) directly into a new column in the query.

Tak for jeres svar, jeg vil gerne tage imod dit tilbud om hjælp, men jeg kan først komme til at sende den i aften, hvis det er ok
M.v.h GVJ

No problem :o)