2 Replies Latest reply: Oct 14, 2016 12:02 PM by Rupam Das RSS

    Date Cal

    Kshitija Shinde

      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!!