topic Compare the date against the current date in QlikView https://community.qlik.com/t5/QlikView/Compare-the-date-against-the-current-date/m-p/211633#M65851 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I have two Questions.</P><P>1.I have a Date which i need to compare it against the current date in set analysis (ie equivalent command for getdate() in SQL)</P><P>2.How to compare the date i have with the selected year in the list box containing the calender year in my application.</P><P></P><P>Thanks.</P></BODY></HTML> Tue, 12 Apr 2011 16:14:44 GMT 2011-04-12T16:14:44Z Compare the date against the current date https://community.qlik.com/t5/QlikView/Compare-the-date-against-the-current-date/m-p/211633#M65851 <HTML><HEAD></HEAD><BODY><P>Hi All,</P><P>I have two Questions.</P><P>1.I have a Date which i need to compare it against the current date in set analysis (ie equivalent command for getdate() in SQL)</P><P>2.How to compare the date i have with the selected year in the list box containing the calender year in my application.</P><P></P><P>Thanks.</P></BODY></HTML> Tue, 12 Apr 2011 16:14:44 GMT https://community.qlik.com/t5/QlikView/Compare-the-date-against-the-current-date/m-p/211633#M65851 2011-04-12T16:14:44Z Compare the date against the current date https://community.qlik.com/t5/QlikView/Compare-the-date-against-the-current-date/m-p/211634#M65852 <HTML><HEAD></HEAD><BODY><P>Hi Suprasanna,</P><P>You can use Now() function for Date &amp; Time Stamp. If you just need Date then use Today().</P><P>Regarding your 2nd question, please post a QV document with sample data and one of us would explain you in detail.</P><P>I hope this helps...</P><P></P></BODY></HTML> Tue, 12 Apr 2011 16:25:47 GMT https://community.qlik.com/t5/QlikView/Compare-the-date-against-the-current-date/m-p/211634#M65852 IAMDV 2011-04-12T16:25:47Z