Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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' ;
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
Hi,
Use solution given above if not worked then try same logic with
to_Char() or to_Date() while comparing.
Regards