2 Replies Latest reply: May 29, 2013 12:03 PM by j i 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?