Let me put my 2 cents. If you know your fiscal date range so you can do comparison like:
************************************************************************************** AND DocDateCreated BETWEEN <cfqueryparam value="Your Start Fiscal Date" cfsqltype="cf_sql_date" /> AND <cfqueryparam value="Your End Fiscal Date" cfsqltype="cf_sql_date" /> ************************************************************************************* If you keep your fiscal date ranges in table, your can join it in sql query. Bu I would recommend run that in store procedure. ************************************************************************************* Also make sure you remove the time from your DocDateCreated field if it there, something like this convert(char(10), DocDateCreated, 101) Regards, Misha On Wed, Jan 30, 2013 at 1:55 PM, Lorenzo Watts <[email protected]> wrote: > > 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:6053 Subscription: http://www.houseoffusion.com/groups/cf-newbie/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/groups/cf-newbie/unsubscribe.cfm
