hi everyone,

I'm trying to find a difference between a datetime field and the current date.
In the textBox i write the following:
   =datediff(day, Fields!date.Value, Globals!ExecutionTime)

Errors:
textbox 'date': Argument 'Interval' is not a valid value
textbox 'date': Argument not specified for the dateValue of Public Function Day(DateValue as Date)

Can you help?
Thanks

=datediff(day, Fields!date.Value, Globals!ExecutionTime)

The day in the above datediff function is a function itself, where it has to be an interval parameter.

You can check the help on datediff function for its syntax and parameters.

Actually the first paramaeter to datediff function should be any of this.

Syntax
DATEDIFF(datepart, startdate, enddate)

Arguments
datepart

Is the parameter that specifies on which part of the date to calculate the difference. The table lists dateparts and abbreviations recognized by Microsoft® SQL Server™.

Datepart Abbreviations
year yy, yyyy
quarter qq, q
month mm, m
dayofyear dy, y
day dd, d
week wk, ww
hour hh
minute mi, n
second ss, s
millisecond ms

In your case you should use dd or d
Hope that helps.
Cheers!

_________________________
-Vijay G
Strive for Perfection

I still got error saying 'dd' is not declared.... sad sad!
The functions given in the WROX text book don't work at all.... humm.... i wonder why

I ended up using the following function:

=DateDiff(dateInterval.month, Fields!date.Value,date.today())

thanks~