Help using WHERE

[bazzaonline]

Hello,  I have the below script and I want to add a WHERE in the script so it only pulls back data where the "D_Claim_Entered" is newer than 30/06/2014.  I can't get it to work.  The date is in the format 01/0/2015 00:00:00.

OLEDB CONNECT TO ...............................................xxx

LOAD   "N_CLAIM_NUMBER" AS "Claim Number",,

    "D_CLAIM_ENTERED",

    "T_SHRT_TXT";

SQL SELECT TOP 1000  "N_CLAIM_NUMBER",

    "D_CLAIM_ENTERED",

    "T_SHRT_TXT"

FROM clementine.dbo."Household_TPC_2013_Onwards_All";

STORE Notes Into Notes.qvd

[alexandros17]

Try with

.....

SELECT "N_CLAIM_NUMBER",

    "D_CLAIM_ENTERED",

    "T_SHRT_TXT"

FROM clementine.dbo."Household_TPC_2013_Onwards_All"

Where N_CLAIM_NUMBER >= '20150101'

.....

let me know

[Gysbert_Wassenaar]

Try

SQL SELECT TOP 1000  "N_CLAIM_NUMBER",

    "D_CLAIM_ENTERED",

    "T_SHRT_TXT"

FROM clementine.dbo."Household_TPC_2013_Onwards_All"

WHERE "D_CLAIM_ENTERED" > '30/06/2014' ;

[#4 · Accepted solution]

Try something like this:

OLEDB CONNECT TO ...............................................xxx

LOAD   "N_CLAIM_NUMBER" AS "Claim Number",,

    "D_CLAIM_ENTERED",

    "T_SHRT_TXT"

Where "D_CLAIM_ENTERED" > Date('30/06/2014', 'DD/MM/YYYY') ;

SQL SELECT TOP 1000  "N_CLAIM_NUMBER",

    "D_CLAIM_ENTERED",

    "T_SHRT_TXT"

FROM clementine.dbo."Household_TPC_2013_Onwards_All";

STORE Notes Into Notes.qvd

[PrashantSangle]

Hi,

Use solution given above if not worked then try same logic with

to_Char() or to_Date() while comparing.

Regards