Dayalan Punniyamoorthy Blog

Saturday, April 3, 2021

Things to note while loading Date Format values using Data Management into EPBCS/PBCS!

We all have loaded non-numeric (Text, Date & Smartlist, etc..) using the Data Management (FDMEE cloud). I thought I will reiterate the common mistakes done while loading the All data types data.

  

  • Check All Data Type (for Delimited or Multi Column)– under File Type in Import Format is selected.

The first step to verify the Import Format is set to Multi Column -All Data Type or Delimeted- All Data Type as Numeric data will not load Date format data.

In this screenshot, i am loading the Date to the member OCX_Purchase Date