Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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)
=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)
=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)
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.
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)
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.