Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi. I only want to se the SECount >0 for today.
Wat's wrong whit this?
[ code ] count (if(SECount>0 and EndTime>=Today(),1)) [ /code ]
Tacks! [:D]
What is the formay of EndTime in your data? Today() is going to return a date: 2/16/2010 (format may differ). If your EndTime is not in that format, the conditional may not return what you expect.
Try putting =Today() in a text box and see what it looks like and then compare that to your EndTime data.
What is the formay of EndTime in your data? Today() is going to return a date: 2/16/2010 (format may differ). If your EndTime is not in that format, the conditional may not return what you expect.
Try putting =Today() in a text box and see what it looks like and then compare that to your EndTime data.
Thank you for the fast answer. it help t me very much!