InfoPath Dev

Hi Jimmy, many thanks for your help, I have found a way around this from another entry on this site. It calculates the difference between 2 dates and out puts this into another field I then take this value and use some conditional formatting to get my traffic light to work.

Hi Jimmy I need it to conform to the same rules, ie if <7 days green / 7 to 30 days amber and >30 days red. Even if someone puts the data into the form with a date in the past. This will be used for a overview of live set of information. I could supply my original spreadsheet with the conditioal formating or I could post the rules ...

Hi Jimmy many thanks for the quick responce, I've tried it out and it works. But I've tried to put in a date in the past and it stays green ! What I'm trying to do is to have the traffic lights compare what ever date you put in with today and it will conform to the traffic lights.I need it to update every time you open the ...

Hi I need to setup a form with a traffic light indicator. I am using MS IP 2003. one date would be from a date picker and compared with todays date (in a repeating table) <= 7 ( days) GREEN 8 to 30 (days) AMBER >30 (days) RED I have managed it in excel 2003 using conditional formatting, but I can't seem to find a way in ...

Hi I'm real new to infopath (2003) I'm trying to create a form with 2 totals one weekendhours and one weekhours, taking the hours from a repeating table. the weekend and week selection will be in a dropdown. I found a formular as follows. sum(DollarValue[Status = "Approved"])   the template I downloaded works but it ...