Discussion board where members can get started with QlikView.
Can any one please help me on below requirement.
I have a table from SQL database
Here the DATE is in DD/MM/YYYY 00:00:00 format. so extracted date with DD/MM/YYYY using to_char function.
By using where condition I have to extract only 2 days data 02/04/2018 and 03/04/2018 and need to store in one qvd only. By defining static also fine.
i have used like this and extracted one day data using where to_Char(DATE,'DD/MM/YYYY') ='02/02/2018';
how to add 03/04/2018 here. Please help me on this
DATE(DATE,'DD/MM/YYYY') as DATE,
to_Char(DATE,'DD/MM/YYYY') AS DATE,
where to_Char(DATE,'DD/MM/YYYY') ='02/02/2018';
where to_Char(DATE,'DD/MM/YYYY') Between '02/02/2018' AND '03/04/2018';
View solution in original post
Use in() or between() in where clause
select * from tableName
where dateField in ('requiredDate','requiredDate')
where dateField between 'FromDate' and 'toDate'
Use where DATE >='02/02/2018' and <='03/02/2018'
have you got this working?
where to_Char(DATE,'DD/MM/YYYY') ='02/04/2018'
OR to_Char(DATE,'DD/MM/YYYY') ='03/04/2018';