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())) )))
Hello John,
Thank you for contacting Infragistics. Please provide a sample application that isolates this issue. I also recommend using the WinCalcManager (if you are not already) and conditionally format the cells by using a formula condition and/or operator condition as needed, explained in the following help topic to determine if the formula above is at fault.
https://es.infragistics.com/help/winforms/wingrid-you-can-now-conditionally-format-cells-in-a-wingrid-column-whats-new-20071
Also, how often is your grid updating? It might not be as performant if the updates occurring within seconds. I recommend that you refer to the WinGrid Performance Guide for how to make your app the most efficient it can be.
https://es.infragistics.com/community/forums/f/ultimate-ui-for-windows-forms/15306/wingrid-performance-guide
Let me know if you have any questions.
Sincerely,
Michael Di FilippoAssociate Software DeveloperInfragistics, Inc.www.infragistics.com/support
Time constraints did not allow me investigate the issue further, my solution was Combine the Date and Time to a new DateTime column on the back end data source and then just used myDateTime>Now()
Thank you for your time
No worries. Thanks for reaching back.
If you have any question please follow up here and we will reach back to you.