G Guest Aug 28, 2007 #1 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
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
G Guest Aug 28, 2007 #2 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
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
G Guest Aug 28, 2007 #3 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 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?
G Guest Aug 28, 2007 #4 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 Hugo C. said: 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 Click to expand... Click to expand...
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 Hugo C. said: 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 Click to expand... Click to expand...
G Guest Aug 28, 2007 #5 What is the error? Where did you try it? Are the two fields type is Date? -- Good Luck BS"D Hugo C. said: 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 Hugo C. said: 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 Click to expand... Click to expand... Click to expand...
What is the error? Where did you try it? Are the two fields type is Date? -- Good Luck BS"D Hugo C. said: 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 Hugo C. said: 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 Click to expand... Click to expand... Click to expand...
G Guest Aug 28, 2007 #6 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 Hugo C. said: 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 Click to expand... Click to expand... Click to expand...
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 Hugo C. said: 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 Click to expand... Click to expand... Click to expand...
