I am attempting to pull data from large (20 million + records) Teradata tables into access. The tables contain records for an entire month, and I want to be able to pull only the records for the previous day. I have not been successful in pulling records by date using traditional SQL (#9/26/2006#). The field in the Teradata table is a DATE field, so I am not sure what I am doing wrong. Any ideas? Thanks!!
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.