Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
45
FormulaCondition checking against the current time
posted

Hello,

I am using an UltraGrid  that has two columns: DueDate and DueTime, I want to set the column text color to green if the event is Due in the future, but I am having trouble writing a formula for this

. I am assigning a dataset to the grid at run time, and in that dataset the DueTime could be null.

I have gotten up to the below formula, but it fails for events on the same day whose DueTime has already passed.

Or([DueDate]>Today(), And([DueDate]=Today(), [DueTime]<>DBNUll(), [Duetime]>time(hour(now()),minute(now()),second(now())) )))

Parents
No Data
Reply Children