- see footer for list info -<
Perhaps someone will correct me but with databases it is best to use the
ODBC date time format which is yyyy-mm-dd (not what I said before, woops).
This /may/ be the cause of the problem. Check the odd date returns to
see if they could be switching the months and days.
Dominic
Stephen Adams wrote:
- see footer for list info -<
But in the Access columns I've set the Format to dd/mm/yy, does that stop
the need to convert the date to American format
On 07/12/05, dominic watson <[EMAIL PROTECTED]> wrote:
- see footer for list info -<
Try storing the dates the American way, mm/dd/yyyy.
Then when you want to display them use DateFormat(theDate, 'dd/mm/yyyy')
Dominic
Stephen Adams wrote:
- see footer for list info -<
Hi,
I'm creating a mini helpdesk site, which records when calls are opened
and
closed. So in my Access database behind it I have two columns, one that
records the date a call is open and one that records when a date is
closed.
Both of these columns are date/time columns with a format of "dd/mm/yy".
So when I try to query the table to a get a list I have been using:
WHERE DateOpen > <cfqueryparam cfsqltype="cf_sql_date"
value="#DateFormat(
arguments.startDate, 'dd/mm/yy')#">
AND DateClosed <= <cfqueryparam cfsqltype="cf_sql_date"
value="#DateFormat(
arguments.endDate, 'dd/mm/yy')#">
But when I run this query I get some results that are out side of the
date
I've entered, so I'm not sure that it is the best way to check between
dates? Is there another way that will give better results?
Thanks
Stephen
_______________________________________________
For details on ALL mailing lists and for joining or leaving lists, go to
http://list.cfdeveloper.co.uk/mailman/listinfo
--
CFDeveloper Sponsors:-
- Hosting provided by www.cfmxhosting.co.uk -<
- Forum provided by www.fusetalk.com -<
- DHTML Menus provided by www.APYCOM.com -<
- Lists hosted by www.Gradwell.com -<
- CFdeveloper is run by Russ Michaels, feel free to volunteer your help
-<
_______________________________________________
For details on ALL mailing lists and for joining or leaving lists, go to
http://list.cfdeveloper.co.uk/mailman/listinfo
--
CFDeveloper Sponsors:-
- Hosting provided by www.cfmxhosting.co.uk -<
- Forum provided by www.fusetalk.com -<
- DHTML Menus provided by www.APYCOM.com -<
- Lists hosted by www.Gradwell.com -<
- CFdeveloper is run by Russ Michaels, feel free to volunteer your help
-<
_______________________________________________
For details on ALL mailing lists and for joining or leaving lists, go to
http://list.cfdeveloper.co.uk/mailman/listinfo
--
CFDeveloper Sponsors:-
- Hosting provided by www.cfmxhosting.co.uk -<
- Forum provided by www.fusetalk.com -<
- DHTML Menus provided by www.APYCOM.com -<
- Lists hosted by www.Gradwell.com -<
- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
_______________________________________________
For details on ALL mailing lists and for joining or leaving lists, go to
http://list.cfdeveloper.co.uk/mailman/listinfo
--
CFDeveloper Sponsors:-
- Hosting provided by www.cfmxhosting.co.uk -<
- Forum provided by www.fusetalk.com -<
- DHTML Menus provided by www.APYCOM.com -<
- Lists hosted by www.Gradwell.com -<
- CFdeveloper is run by Russ Michaels, feel free to volunteer your help -<
