Hi Phillip, try something like this:
select year + "-" + month + "-" + day as full_date cheers, Toby Thursday, September 11, 2003, 2:45:39 PM, you wrote: PB> I am moving data from a poorly designed table to a new beter table. They PB> stored the date in the table in three int fields month, day, and year. I am PB> going to move the data to a new table with one field that is a date type. PB> How can I write the query to make the old ints into a date with out using PB> CF? I tried versions of this but none worked. select month + day+ year as PB> date PB> Man Im fried. PB> Phillip B. PB> www.LoungeRoyale.com PB> www.FillWorks.com PB> ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/lists.cfm?link=t:6 Subscription: http://www.houseoffusion.com/lists.cfm?link=s:6 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=<:emailid:>.<:userid:>.<:listid:> Your ad could be here. Monies from ads go to support these lists and provide more resources for the community. http://www.fusionauthority.com/ads.cfm
