16 Replies Latest reply: Jun 19, 2016 5:16 PM by Clever Anjos RSS

    DERIVING DATE ,YEAR AND MONTH FIELDS FROM A DATE

    qvhelp please

      Hi Everyone,

       

      i am trying to derive the date ,month and year fields from a date but the data in tat date field is incosnistent i am using the date# and date functions to manipulate the data but its not working .

       

       

      syntax i am using :date(Date#(DateOfBusiness,'MM/DD/YYYY')) as Date,

      Attached is the date i am using .please do help

      kush141087gwassenaarrwunderlichmaxgrostalwar1cleveranjos