There is a DocDateCreated field with a dateTime datatype but the fiscal year runs from July 1 to June 30. Do you know of a way to do this in the output?
>Ah, ok. > >That's not going to work. Is there a date field in the database for each >record? > >If not, you'll have to do it in your output after all I think. > >w > >I'm using MsSql and the data type for DocFiscalYear is varChar > >>WHERE (DocAdmin_Users.UserUserID = <cfqueryparam >value="#cfcUserUserID#" >DocAdmin_FiscalYear.Active, >> DocAdmin_FiscalYear.SortOrder AS >>FiscalYear_SortOrder, DocAdmin_Access.UserID AS UserId, >DocAdmin_Users.UserUserID AS UserUserId, >value="#cfcUserUserID#" ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Order the Adobe Coldfusion Anthology now! http://www.amazon.com/Adobe-Coldfusion-Anthology/dp/1430272155/?tag=houseoffusion Archive: http://www.houseoffusion.com/groups/cf-newbie/message.cfm/messageid:6052 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
