dates

[Hugo C.]

I have 2 dates 05-12-07 and 31-07-07
i want to make the diference beetwen those 2 (first - second)

how can i do that

 

[Ofer Cohen]

Using the function DateDiff you can get the difference between two dates
(check help on the options you have: month weeks days etc)

DateDiff("d",[FirstDate],[SecondDate])

will give the difference in days between two dates

 

[scubadiver]

The datediff function will do it for you.

DateDiff("h", [START_MK], [STOP_MK])

the "h" represents hours though you can change it days, months, weeks or
whatever.

Do you want to exclude weekends and bank holidays?

 

[Hugo C.]

I tried

DateDiff("d", [dat_venc], [data])

but it says that as a mistake ...

what could it be?

"scubadiver" escreveu:

The datediff function will do it for you.

DateDiff("h", [START_MK], [STOP_MK])

the "h" represents hours though you can change it days, months, weeks or
whatever.

Do you want to exclude weekends and bank holidays?


--
The 11th day of every month:

http://truthaction.org/forum/index.php

I have 2 dates 05-12-07 and 31-07-07
i want to make the diference beetwen those 2 (first - second)

how can i do that

 

[Ofer Cohen]

What is the error?
Where did you try it?
Are the two fields type is Date?

--
Good Luck
BS"D

I tried

DateDiff("d", [dat_venc], [data])

but it says that as a mistake ...

what could it be?

"scubadiver" escreveu:

The datediff function will do it for you.

DateDiff("h", [START_MK], [STOP_MK])

the "h" represents hours though you can change it days, months, weeks or
whatever.

Do you want to exclude weekends and bank holidays?


--
The 11th day of every month:

http://truthaction.org/forum/index.php

I have 2 dates 05-12-07 and 31-07-07
i want to make the diference beetwen those 2 (first - second)

how can i do that

 

[Hugo C.]

thanks i manage to solve my problem ...

the formula worked it was a comma mistake ...

Thanks for everything and 4 ur time ...

"Ofer Cohen" escreveu:

What is the error?
Where did you try it?
Are the two fields type is Date?

--
Good Luck
BS"D

I tried

DateDiff("d", [dat_venc], [data])

but it says that as a mistake ...

what could it be?

"scubadiver" escreveu:

The datediff function will do it for you.

DateDiff("h", [START_MK], [STOP_MK])

the "h" represents hours though you can change it days, months, weeks or
whatever.

Do you want to exclude weekends and bank holidays?


--
The 11th day of every month:

http://truthaction.org/forum/index.php


:

I have 2 dates 05-12-07 and 31-07-07
i want to make the diference beetwen those 2 (first - second)

how can i do that