Error in Expression !$@&^#

[#1]

Hello again all,

I keep getting this while creating an expression!

count(Maintenance)

=count(if(StartDate <= CurrentDate) and (StartDate <= CurrentDate) and

(StartDate >= CurrentDate) and (StartDate >= CurrentDate));

What am I doing wrong!?!

Thanks in Advance!

[#2]

What ??

Let me reduce your if condition to its effective part:

StartDate = CurrentDate

Please try to add some more details what you try to do.

[#3]

Hi,

You can write in this way

count(if(startDate<=CurrentDate and startDate>=CurrentDate ,Maintenance))

You have written "startDate<=CurrentDate " two times which i am not able to understand i think this should be one time only if condition is same and fields are same.

Regards,

Ravi

[#4]

MY BAD SORRY! IT SHOULD BE MORE LIKE THIS:

=count(if(StartDate <= CurrentDate) and (StartTime <= CurrentTime) and

(EndDate >= CurrentDate) and (EndTime >= CurrentTime));

[#5 · Accepted solution]

Hi!

It looks like your expression is not completed. To make it easier I will break it down:

=count(

if(

StartDate <= CurrentDate and StartTime <= CurrentTime and EndDate >= CurrentDate and EndTime >= CurrentTime

,Maintenance

)

);

Remember the if statement works like:

if( criteria=met

,THEN

,ELSE)

BR

Jakob Berglund