In Qliksense for Date picker How to add/syntax for OR condition to get required Data .

[chinni]

Hyy

I am using Date Picker for picking the From &To date to get only the required data from the Table to download. 

Here in Date Picker In Advanced setup I had given Timestamp field column. 

For that I have used Syntax ->  =date(floor(my_TimeStamp_Field) 

So my concern is that Date Picker should consider another column along with the TimeStamp field.. 

So I tried like this.. =date(floor(my_TimeStamp_Field))  or (I_Column) 

Here I'm not getting whether the syntax for OR condn i am used is proper or not.. 

But it's not working... 

can anyone help... 

Thanks much.... 

[vinieme12]

As below

=date(RangeMax(floor(Timestampfield),floor(Other field)))

Use RangeMax() or RangeMin() as required 

[chinni]

Hy 

will try and let u know.. 

[chinni]

Hy 

If we want to use two TimeStamp field Columns in Date picker...then what was the Syntax for that.. 

And I need to know one more... 

If One  is Timestamp field and other is some Report field in Date picker... 

Previously this Report field is in format yyMM but need to change the format to- yyyy-MM-DD. (where only Date should be constant) like these pattern 2020-02-17, 2020-03-17....

Can anyone help with this issue..