if codition

[marksmunich]

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)

[MK_QSL · Accepted solution]

=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)

[jagan]

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.

[marksmunich]

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)

[marksmunich]

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.