I need to be able to set a date in the application.cfm file for example <CFSET APPLICATION.stopdate='10/15/2014'> Then in my site on other pages I have code that says <cfif reportdate GT…
I need to convert my minutes in my HH:MM record to decimal. For example if I have 43 hours and 15 minutes (43:15) I need to return the result 43.25 hours and if i have 10 hours and 30 minutes I…
So here is the logic I have I just can t figure how to code If the date is between 5/31/2014 after 3:00 PM and 6/7/2014 up to 3:00PM <CFSET payweek =1> If the date is between 6/7/2014 after…
I need to query and get all records that have been updated in the past 15 minutes. Ive tried in CF and MS SQL Here is what I have that doesn't work SELECT * FROM job_clock WHERE …