dateadd()

[benjamin.weizmann]

hi
I just want to clear it

Does the function dateadd "understand" fractions ?
for example: I need to write DateAdd("yyy", 0.5, curredate1) as DateAdd("m", 6, curredate1) or the first pattern is ok?

thanks u

Ben

 

[Minty]

No - from MS help; "If number isn't a Long value, it is rounded to the nearest whole number before being evaluated."

Use the specific values for months in your example.

 

[arnelgp]

Dateadd only accepts whole number, thatbis the wholepart is only recognized.