Thanks for the reply. I'll try that IF on Monday when I get back to the office and comment back then.
THe the first question basically I'm looking for the Qlik syntax for a datediff calculation. service date minus billed date would give me the number of days it took for a bill to go our the door. I am currently using the floor function ( FLOOR(service_date,billed_date) ). I am just not positive that it's the appropriate way to get a date difference between the two fields.