antal dages forskel

datediff

Datediff(\"d\";[Startdato];[Slutdato])

Den giver dig afstanden mellem 2 datoer

Eller bare:
  Int(Now() - [starttidspunkt])
  Int([sluttidspunkt] - Now())

DateDiff(\"d\"; [start tidspunkt]; Now())
DateDiff(\"d\"; [sluttidspunkt]; Now())

SELECT DateDiff(\"d\", [start tidspunkt], Now()) AS Started, DateDiff(\"d\", [sluttidspunkt], Now()) AS Ended;

Er der gået inflation i gode løsninger ???  ;-)

questions seem hard to come by at the moment :o)

The Christmas-hollidays is perhaps extended this year...

=Datediff(\"d\";#24/12/01#;Date())

What am I doing here then?

Kanon tak skal I alle have!

mange tak :o)

mange tak :o)

Hejsa igen!!

Jeg havde lige endnu et spørgsmål:

Hvis min tabel heller \"opgaver\" og feltet for startidspunktet hedder \"starttid\" og slut feltet hedder \"sluttid\"

Hvordan skriver man så hele SQL sætningen i Access??

Jeg kan ikke få det til at virke! (den skal regne forskellen ud for hver post i tabellen)

---------------------------
DateDiff(\"d\"; [start tidspunkt]; Now())
DateDiff(\"d\"; [sluttidspunkt]; Now())
----------------------------

PRØV MED:

SELECT *, DateDiff(\"d\", starttid, Date()) AS Tid1, DateDiff(\"d\", Date(), sluttid) AS Tid2 FROM Opgaver;

Den skriver syntax error (missing operator) in query expression  \'DateDiff(\"d\", .Obegyndelse, Date())\'

hvad kan der være galt?? og hvad står \"d\" for??

du skal fjerne .\'et (punktummet) før Obegyndelse...

looking at the error \'DateDiff(\"d\", .Obegyndelse, Date())\' it looks as though there is an error in the second (sluttid) datediff syntax. Try reomoving this so you only have the first (starttid) and see if it works. If it does then you will need to look at the syntax for your sluttid.
\"d\" is for days. There are also other pramaters such as \"y\" amd \"w\"

Thank you so very much