Select Query

[farolito20]

How I can do this query in an expression in QlikView?

SELECT *

FROM Person.Password

WHERE ModifiedDate>'1996/07/23'  and ModifiedDate<'1997/03/20'

[#2]

If you read a QVD, you can read the table and put a where.

select *

from QVD.TABLE

Where ModifiedDate> 'date1' and ModifiedDate < 'data2'

[farolito20]

Yes, but the select doesn't work in expressions 😕

[farolito20]

I wanna put that condition in a text object

[#5]

if so use the expression to return the values ​​in the object.

= if (ModifiedDate> 'date1' and ModifiedDate <'data2', 'Field Object)

[farolito20]

Thanks

[#7]

Good morning,

Did it work? So mark my answer as correct, please!

[farolito20]

I didn't use your answer, but that gave me an a good idea