1 Reply Latest reply: Apr 17, 2013 7:10 PM by adjrockq RSS

    Create calendar using date format dd/mm/yyyy hh:mm:ss

      Hi All,

      I am trying to create a data calendar with a data format that was originally as stated in the subject. I was not interested in the time stamp, therefore from the QVD itself, I rid mysel of the time stamp by using the date function, however, when I create a get convert it to number using NUM function, I get numbers followed by 4 decimal points. As a result I cannot match it to the autogenerated calendar when I convert the number back to date. Hope someone can understand my predicament.