5 Replies Latest reply: Sep 24, 2018 9:42 AM by Ashish Palkar RSS

    How to use SQL Dateadd function in Qlik

    Ashish Palkar

      Hi There

      I am using following SQL statement and want to use same in Qlik. Any suggestions how to use Dateadd in Qlik. In below example user is inserting random date which will be added to selected business date and results will be shown.

      ISNULL(I.maturitydate,I.ExpiryDate) between @BusinessDate AND DATEADD(d,@DaystoMaturity,@BusinessDate)

      Thanks in advance.