3 Replies Latest reply: May 30, 2011 1:57 AM by Mikael Långström RSS

    Combining Integer and date

    Mikael Långström

      Hi!

       

      I'm trying to combine Integer '1234' and Date together.

      I've tried everything but QV keeps changing my datatype to text.

       

      Here's an example:

      INTEGER&date(DATE,'YYYYMMDD') as FINALRESULT

       

      I want FINALRESULT to be in Integer format not in String because I need to use Intervalmatch later.

       

      Thank you!!!

       

      -Mikael