Date related font change

[Dspguards]

Hi Guys,
I have a date field that we use to input the exp date of licenses. Im trying to set up the client side conditional style to show this date as red when the system date is = to or past it.
i have tried setting it as "field"=>date() and Field=>D_Date() both of which return an error "date" is undefined or D_Date is undefined.
Needless to say its driving me a little around the bend.
Any help would be great

Thanks
Roland

[2ninerniner2]

Re: Date related font change

Hi Roland,

You don't mention what you are using for a database so I am not sure this is the same in your case, but I have just tried this on a test app that uses MySQL with the date field being of the DATE type and this is what I entered for the condition:

field >= now()

Works for me :)

Cheers!
Lyle

[Davidk]

Re: Date related font change

Dates drive me crazy. There are two areas for Conditional Styles: Display Settings (this is Server-side) and Client Side Properties. I just can't get anything to work under the Server side... such a pain... probably very simple, but it's eludes me. field >= now() results in an error - it doesn't understand now. I get an error putting this into the Client side as well... I don't get it.

Display Settings is better, but still... I can get OrderDate="01/03/2012" to work... remember that you have to work with text 'cause it's client side. But I can't get the current date in there for testing... that is... without using a function.

So, put in field >=condDateTest()

And, in your Javascript Functions put this...

function condDateTest() {

var currDate = new Date();
currDay = currDate.getDate();
currMth = currDate.getMonth()+1;
currYr = currDate.getFullYear();
frmtDate = currDay + '/' + currMth + '/' + currYr;
return frmtDate;

}

That works.

[2ninerniner2]

Re: Date related font change

David -

Not sure why it's not working for you. As mentioned, in this example, the date_hire field is of the DATE type in MySQL and here are screenshots of the result plus the two settings. I just used the first "Conditional style" 'thingy' I saw, and it just worked no muss, no fuss, no code :)

conditional_date_grid.JPGconditional_date1.JPGconditional_date2.JPG

Cheers!
Lyle

[2ninerniner2]

Re: Date related font change

Just noticed this ...

remember that you have to work with text 'cause it's client side

Why? This could be why now() is not working. I didn't have to change anything like that in 'Display Settings' ... just used it as it came out of the MySQL table as DATE.

[agillbb]

Re: Date related font change

Or look at this solution from a few days ago...
http://msgboard.alphasoftware.com/al...-comparison%29

[Dspguards]

Re: Date related font change

Yet again all sorted thanks to all your help.
Thanks again.

[Davidk]

Re: Date related font change

Sometimes you just can't see it, unless you "see" it. Thanks for the images, Lyle. I matched my field and condition to yours... still getting an error. Then I looked again, closely, at your images and realized that my Control Type for my Date is a Textbox... yours is a Label. I changed mine to a label and all is good. It seems a function is required for dynamic date comparisons if the control type is a Textbox. A Static comparison is fine... no function required.

[2ninerniner2]

Re: Date related font change

David -

Umm ... seems to work just fine with an editable Textbox control too

conditional_date_textbox_a.jpgconditional_date_textbox2a.jpgconditional_date_textbox3a.jpg