Hi Friends,
I have to write If function and Where function and In that where function we have to place Relative date function. for this I have written the below code but I ma getting the error.
=If(( [Integrate Status] = “P”); 1; 0) Where( [Week End Date] <= (RelativeDate([Week End Date];14))
Could you please assist
Regards,
Eswar
eswar519 (BOB member since 2009-05-26)
First of all, why would you need your where clause if it is always true?
Dmitry Grekov 
(BOB member since 2009-09-29)
Actually My requirement is
Total number of timesheets signed and submitted§ where the timesheet has been signed and submitted within 14 days of the Monday following the Time Period End Date.
For this purpose I have written the code like
=If(( [Integrate Status] = “P”); 1; 0) Where( [Week End Date] <= (RelativeDate([Week End Date];14)).
How can I write the formuale for the above one. Could you please assist me.
Regards,
Eswar
eswar519 (BOB member since 2009-05-26)
In your WHERE clause there is paraenthesis mismatch, it should be:
Where([Week End Date]<=RelativeDate([Week End Date];14)) but I am not sure whether you can use this with if and what will be the result
Prashant Purohit 
(BOB member since 2009-02-18)
If you follow the link supplied by Jansi you could find that no comparison operators other then " = " are allowed in Where () function.
But it is not a problem - you can always check the sign of
=Sign(DaysBetween([date1];[date2]))Dmitry Grekov (BOB member since 2009-09-29)