4 Replies Latest reply on Dec 6, 2020 11:47 PM by Debopriya Roy

    Import perspective showing -1 date and loading incorrectly

    Debopriya Roy Guru

      Hi All,

       

      In PIM v8.1.1.05, when feed file is opened in excel, date is showing properly in mm/dd/yyyy (12/3/2020) format.

      But when its loaded into rich client the format changes to yyyy-mm-dd  (12-02-2020) and date value has changed to one day earlier value (2020-12-02).

      Please note that xlsx file is opened and import project is opened in server timezone only.

       

      Screenshots attached. Any idea what wrong settings might lead to this? Import date settings are same in two environments and this issue seems to be happening only in one of them.

       

      Thanks in advance,

      Debopriya