Conditional Image in Grid

[agillbb]

Hi,
I would like display a dynamic image (red dot) next to each row, and need to check whether each date field (TriggerDate) is less than today's date. I need a client-side conditional image rule to determine whether to display the image. I have tried:

TriggerDate<=time('mm/dd/yyyy')

It does not work, and the help is non-existent for dates and date functions. Any help would be welcomed....

[Davidk]

Re: Conditional Image in Grid

Sometimes, success with dates is a bit tough, always possible, but troublesome at times. What database are you using and what date format is being used? I just tried this and it works well. I added an image and set one condition. I didn't really type anything in for the condition, I inserted a field, put in the operator "<" and then inserted a function, as in the images attached. I'm using MySQL tables. In the table, the format of the date is 2011-12-16. I doubt you want to use the time function... but I don't know what format your TriggerDate is in. Just use the Date() function for todays date.

[agillbb]

Re: Conditional Image in Grid

Thanks,
I will let you know how it works out...
Andy.

[agillbb]

Re: Conditional Image in Grid

David,
The problem I am getting is that the grid initializes and displays correctly at first, but if you edit the date so that the image condition has changed, the image does not refresh itself. Can you try editing your date in the grid and see if you get the same issue? (This is why I was trying the client-side condition in case it solved the server-side problem). Either it is a bug, or I am missing something.
Thanks,
Andy.

[Davidk]

Re: Conditional Image in Grid

I think the whole thing comes down to date formats... again... things get picky. I believe this may be the only way to accomplish what you want to do... given that your column date is in a format of dd/mm/yyyy.

Click on Javascript Functions - left side under Code and enter the following date formatting function.

function getFulldate()
{
var d = new Date();
var curr_day = d.getDate();
var curr_mth = d.getMonth();
var curr_yr = d.getFullYear();
var fullDate = curr_day + '/' + curr_mth + '/' + curr_yr;
return fullDate;
}

Now, for your image you can set up a conditional image, client side like this...

OrderDate <= getFulldate()

You may also have to set up a condition if the date is greater than the current date. If you want to have a blank image, then you'll need to create one and add it to your project - then you can use it.

Does this make sense? You're right in that using a client side condition seems to be the only way to get the conditional image to show upon a date change.