Good evening! Please tell me why this formula always gives me TRUE: IF(OR(AND(NOW() > โ005:00:00โ, NOW() < โ007:00:00โ), AND(NOW() > โ017:00:00โ, NOW() < โ019:00:00โ)), [ะัะตะผัะะฑั ะพะดะฐ] = โ17:00/05:00โ, IF(OR(AND(NOW() > โ007:00:00โ, NOW() < โ017:00:00โ), AND(NOW() > โ019:00:00โ, NOW() < โ005:00:00โ)), [ะัะตะผัะะฑั ะพะดะฐ] = โ07:00/19:00โ, TRUE))
What am I doing wrong?
NOW() returns the Date and Time. It looks like you may want to use TIMENOW().
I did not look at the substance of you expression, so there may be other problem also.
@Philip_Garrett_Appsh Did not helpโฆ
ะฃัะปะพะฒะธะต ัะปะตะดัััะตะต: AM 5 - 7 = 17:00/05:00 AM7 - PM5 = 07:00/19:00
PM5 - 7 = 17:00/05:00 PM7 - AM5 = 07:00/19:00 Translate
User | Count |
---|---|
39 | |
35 | |
29 | |
23 | |
18 |