5 Replies Latest reply: Oct 17, 2016 1:20 AM by Kshitija Shinde RSS

    Date ()

    Kshitija Shinde

      Hello everyone,

      i have date in following format 07/09/2016 08.55 PM need to find the month and year for the following date.Made use of the Function Month(),Year(), Date(Date#([Date field], 'dd/MM/yyyy hh.mm pp'), 'M/d/yyyy') as open_Date but all are giving blanks.Can anyone Suggest?.

      Thanks in advance!!