4 Replies Latest reply: Sep 18, 2014 5:03 AM by Mark Munich

# if codition

Hello Community,

Can some one say how to solve this condition. It is not working with the two time Limits, how to set upper and lower time Limits . It is working fine with one time codition but not with two conditions.

If(Wildmatch(weekday(today()),'Mo','Di','Mi','Do','Fr' ) AND

time(now()) > time(Time#('09:00:00','hh:mm:ss')) AND

time(now()) < time(Time#('09:30:00','hh:mm:ss')),1,0)

• ###### Re: if codition

=IF(WildMatch(Lower(WeekDay(Today())),'*mo*','*di*','*mi*','*do*','*fr*') and

Time(Frac(Now())) > Time(Time#('09:00:00','hh:mm:ss')) and

Time(Frac(Now())) < Time(Time#('09:30:00','hh:mm:ss')),1,0)

• ###### Re: if codition

Thanks Manish, the Problem was caused by Frac() function.

Iam using this now:

If(Wildmatch(weekday(today()),'Mo','Di','Mi','Do','Fr' ) and

Time(Frac(Now())) > Time(Time#('09:00:00','hh:mm:ss')) and

Time(Frac(Now())) < Time(Time#('10:30:00','hh:mm:ss')),1,0)

• ###### Re: if codition

Hi,

Try like this

If(Wildmatch(weekday(today()),'*Mo*','*Di*','*Mi*','*Do*','*Fr*' ) AND

time(now()) > time(Time#('09:00:00','hh:mm:ss')) AND

time(now()) < time(Time#('09:30:00','hh:mm:ss')),1,0)

Regards,

jagan.

• ###### Re: if codition

Problem is solved jagan.

If(Wildmatch(weekday(today()),'Mo','Di','Mi','Do','Fr' ) and
Time(Frac(Now())) > Time(Time#('09:00:00','hh:mm:ss')) and
Time(Frac(Now())) < Time(Time#('10:30:00','hh:mm:ss')),1,0)

Thanks anyways for the quick Response.