topic Re: Comparing Dates in QlikView https://community.qlik.com/t5/QlikView/Comparing-Dates/m-p/923506#M319774 <HTML><HEAD></HEAD><BODY><P>Then you first have to join the two tables into one table.</P></BODY></HTML> Fri, 31 Jul 2015 15:01:50 GMT Gysbert_Wassenaar 2015-07-31T15:01:50Z Comparing Dates https://community.qlik.com/t5/QlikView/Comparing-Dates/m-p/923503#M319771 <HTML><HEAD></HEAD><BODY><P>Question for everyone.&nbsp; I have a customer master table and a billing table.&nbsp; I need to compare a date from the customer master with a date from the billing table.&nbsp; Any ideas?</P></BODY></HTML> Fri, 31 Jul 2015 14:15:11 GMT https://community.qlik.com/t5/QlikView/Comparing-Dates/m-p/923503#M319771 tmumaw 2015-07-31T14:15:11Z Re: Comparing Dates https://community.qlik.com/t5/QlikView/Comparing-Dates/m-p/923504#M319772 <HTML><HEAD></HEAD><BODY><P>You can use an if statement to compare them: If( [CalendarDate] = [BillingTableDate], <EM>this</EM> , <EM>that</EM> )</P></BODY></HTML> Fri, 31 Jul 2015 14:18:45 GMT https://community.qlik.com/t5/QlikView/Comparing-Dates/m-p/923504#M319772 Gysbert_Wassenaar 2015-07-31T14:18:45Z Re: Comparing Dates https://community.qlik.com/t5/QlikView/Comparing-Dates/m-p/923505#M319773 <HTML><HEAD></HEAD><BODY><P>The dates are on two different tables and I am trying to do this through my load script.</P></BODY></HTML> Fri, 31 Jul 2015 14:58:36 GMT https://community.qlik.com/t5/QlikView/Comparing-Dates/m-p/923505#M319773 tmumaw 2015-07-31T14:58:36Z Re: Comparing Dates https://community.qlik.com/t5/QlikView/Comparing-Dates/m-p/923506#M319774 <HTML><HEAD></HEAD><BODY><P>Then you first have to join the two tables into one table.</P></BODY></HTML> Fri, 31 Jul 2015 15:01:50 GMT https://community.qlik.com/t5/QlikView/Comparing-Dates/m-p/923506#M319774 Gysbert_Wassenaar 2015-07-31T15:01:50Z