I have a form to show information for each quarter of the year (in a table). I need for users to only be able to update the current quarter- the past quarters should show but be display only. I have a table that lists the dates for the beginning/end of each quarter. My table has the fields: BegQuarter EndQuarter QuarterNo. I was thinking I could do some query that said If Now() is between #BegQuarter# and #EndQuarter# set quarter as #QuarterNo# What would I do next? How do I make it so it will only update that current quarter? I thought of doing cfset currentquarter as #QuarterNo#- but will that be a problem in the future (bec. each year has 4 quarters.) Thanks, ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~ Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm Archives: http://www.mail-archive.com/cf-talk@houseoffusion.com/ Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
