Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
sidhiq91
Specialist II
Specialist II

@robstar256  I used below data as sample for my front end evaluation:

NoConcatenate
Temp:
Load * inline [
HIDate
6/27/2022
6/25/2022
6/26/2022
6/23/2022
06/22/2022
];

Exit Script;

Backend Expression in the Straight table:

=if(Date(Date#(HIDate,'MM/DD/YYYY'),'MM/DD/YYYY')=Date('6/27/2022','MM/DD/YYYY'),1,0)

Comparing Dates.PNG