LAST WEEK SELECT

Thread View: borland.public.intrabuilder.data.sql

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by SG Fri, 23 Jan 1998 00:00

#39

Author: SG
Date: Fri, 23 Jan 1998 00:00

12 lines
932 bytes

Hi, 
Help me please with date() selection from Access table.
1) If I want to retrieve from "in_date" field (with date/time type) only
last week (last month) data, how looks SELECT clause? (SYSDATE-7) not
accepted in Access and I can't find fitting function that works. 
2) The IB's Date() gives date in format 0/23/98 But if I want to
retrieve this record whith correct date (1/23/98) to show  in the form
component?

If you know how, answer please. Thanks.
SG

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads