Dayalan Punniyamoorthy Blog

Showing posts with label Loading Date. Show all posts
Showing posts with label Loading Date. Show all posts

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