LAST WEEK SELECT

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

Article #39

Back to borland.public.intrabuilder.data.sql Previous Next

#39

From: 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

Technical Details

Message-ID: <34C811A0.44DB@impar.com>

Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 101d9a,2e8835bcf3601934,start
X-Google-Attributes: gid101d9a,public
From: SG <svegan@impar.com>
Subject: LAST WEEK SELECT
Date: 1998/01/23
Message-ID: <34C811A0.44DB@impar.com>
X-Deja-AN: 318498312
Content-Transfer-Encoding: 7bit
Content-Type: text/plain; charset=us-ascii
Organization: None
Mime-Version: 1.0
Reply-To: svegan@impar.com
Newsgroups: borland.public.intrabuilder.data.sql