If all the times in the db are set to midnight, then Carl's version works.
If not, I believe this will do it:
<cfset begindate = #CreateDateTime(DatePart('yyyy', Now()), DatePart('m', Now()), DatePart('d', Now()), 0, 0, 0)#>
<cfset enddate = #CreateDateTime(DatePart('yyyy', Now())...
"The nice thing about Date/Time data is the time portion is assumed. If it's absent in the SQL, the driver should automatically assume that you're talking about midnight. So you don't need to do any further formatting."
But we don't know about the values in the database. They could...
Hi,
No, the term1 and term2 columns are set in the database not to allow nulls. If there's no term1 or term2 date for a given record, then there's just a 0 in that field (it's actually not a date datatype, just a number like 2002123, a combination of year and julian day of the year).
Thanks.
I want to make sure I'm doing this query correctly.
There are two tables of interest, let's call them plans and transactions.
In the plans table, there are two columns that serve as a combined key - tan and pin.
Tan is an employer number and pin is an employee number. There can be employees...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.