2 Replies Latest reply: May 29, 2013 12:03 PM by Juan Vitantonio RSS

    Date# resturn small decimal

      Hi All,


      I am working on the for next loop on the date. And want to convert the date to number.


      Let vYesterday = Num(Today(1)-1);

      Let vMaxDateInQVD = Date($(vYesterday)-10);

      Let vTest = Date#($(vMaxDateInQVD));


      but the returns are:

      vTest     "0.00013799194127063"

      vMaxDateInQVD     5/18/2013

      vYesterday     41422


      Why the vTest is a small decimal? I suppose it should be an integer likes vYesterday - 10


      Is there anyone help?