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,
No worries. Thanks for reaching back.
If you have any question please follow up here and we will reach back to you.
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
Thank you for your prompt response, and the links! Hopefully aid me in my solution
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.