Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i am using if condition to display field on basis of reload time as if(time(reloadtime()>=' xyx' and time(relaodtime())=<'abc' and date(reloadtime())=date(today()),concat(field)) . but more than 2 and condition is not working. is there any way to display field on basis of above reload time.
Without going to alternative. I can tell you that there is no such restriction in use of number of ANDs. If placed properly, it should work fine.
try like:
If( Time(ReloadTime())>=' xyz' AND Time(ReloadTime())<'abc' AND Date(ReloadTime())=Date(Today()) , Concat(field))
Hi Piyush,
Try this if(time(reloadtime()>=' xyx', if(time(relaodtime())=<'abc',if(date(reloadtime())=date(today()),concat(field)))))
What I mean is..try putting it in loops,multiple AND conditions might not work in your case.
Hope this Helps,
Please get back to me with your result,if possible share your qvw.
Thanks,
Rochelle
hi, try like this
if(time((reloadtime()>=' xyx') and( time(relaodtime())=<'abc') and (date(reloadtime()))=date(today()),concat(field))
wrap each AND in extra parentheses.
thanks for your suggestion but still its not working.
thanx john, i have tried the above option but still its not working.
hi, treseco
i hav tried but its not working
Can you please share your sample app?
means a problem in calculation instead of the syntax.
join tresesco, lay out the project