Greets,
Ok, so I have this generated report that has dates formatted as a number
(yyyymmdd). Now, when I import this report (text file) into Access, it
only sees it as a Number. Here's my problem. As you can imagine, this
format is useless for doing date comparisons with other tables.
How do I convert this number into a useable date format?
I've tried various permutations of the following with little success:
<cfoutput query="GetDates">
<cfset mo = Mid(FromCert, 5 ,2)>
<cfset da = Right(FromCert, 2)>
<cfset yr = Left(FromCert, 4)>
<cfset startdate = DateFormat(CreateDate(yr,mo,da), "mm/dd/yyyy")>
<cfquery name="update" datasource="PPSData">
UPDATE tblPPSRetro
SET EpisodeStart = <cfqueryparam cfsqltype="cf_sql_date"
value="#startdate#">
</cfquery>
</cfoutput>
If I do a straight cfoutput (without the update query) the results are
as expected (results to the screen/web page) in that I get every date in
the column. But as soon as I add the cfquery - it goes all wonky and
repeats only one date all the way down (and not even the correct date).
Any and all help would be greatly appreciated.
Thanks,
Judith
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Special thanks to the CF Community Suite Silver Sponsor - New Atlanta
http://www.newatlanta.com
Message: http://www.houseoffusion.com/lists.cfm/link=i:15:529
Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/15
Subscription: http://www.houseoffusion.com/lists.cfm/link=s:15
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.15
Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
