subtract 2 date coulmn into query

[BrOkEn_iCe]

subtract 2 date coulmn into query ,how?

hi all
i try many wayes to subtract a 2 dates coulmn in a query and i failed

i want to subtract start_dates coulmn and end_dates coulmn to get the number of dayes between them how i can do this

 

[BrOkEn_iCe]

Can any one help me , plz

 

[rainman89]

check out datediff
http://www.techonthenet.com/access/functions/date/datediff.php

 

[BrOkEn_iCe]

but datediff work only with me in vba not in query

 

[BrOkEn_iCe]

in query it return this error

invalid syntex

i use this code

exp2ateDiff ("yyyy", #15/10/1998#, #22/11/2003#)

 

[rainman89]

Thats not true

Create another column and call it

difference: DateDiff("d",[Start_date],[end_date])

 

[BrOkEn_iCe]

i try it several tim and it keep tilling me invalid syntex
you enter in vailed character or comma why that i don't know

 

[rainman89]

Can you post exactly what you are trying? Are your start_dates and end_dates stored as dates?

 

[BrOkEn_iCe]

i will attach the simple database and can u make it

 

[BrOkEn_iCe]

u can see the attach and know what i need

 

[BrOkEn_iCe]

is there any one can help i need this so much

 

[JamesMcS]

Post number 6's solution works fine.

difference: DateDiff("d",[Start_date],[end_date])

Rainman is exactly right. Copy the text above into a new column after end_date in your query design and it will work fine.

 

[JamesMcS]

To answer your question in post 7 - the "d" tells the datediff function that you want the result displayed in days. If you were to put "yyyy" in there it would return the number of years between the two dates.

Have a look at the help file, it will explain everything.

 

[BrOkEn_iCe]

i am trying this code many times and it keep tilling me
" invalid syntex
you enter in vailed character or comma why that i don't know"

 

[JamesMcS]

Sorry my friend, you must be entering it wrong. I downloaded your DB, put it in your query and it works 100%.

Have a look at the query in your DB, I've done it and attached it for you. I copied Rainman's query text straight into your DB and it works fine.

 

[BrOkEn_iCe]

thx i know what i am doing wrong i writ a (,) and it must be (

have a good day have a good luck and thx one more time

 

[JamesMcS]

Other way round chap but glad it works OK

 

[rainman89]

Glad you figured it out.

 

[JamesMcS]

Go Team AWF!