DateTime Parse/ DateTimeFormat returns Not a Valid DateTime

rahuldale

Hi All,

I am trying to convert the the string column having dates and time into DateTime format. However I am stuck with the below error:

The string data fields are as below:

And I need the dates to be converted in the format as below: - 

StartDate to be converted as "mm/dd/yyyy hh:mm:ss" (Field Type: DateTime)

EndDate to be converted as "mm/dd/yyyy hh:mm:ss" (Field Type: DateTime)

FromDate to be converted as "mm/dd/yyyy" (Field Type: Date)

ToDate to be converted as "mm/dd/yyyy" (Field Type: Date)

I will be using an Excel file as input source and appending these rows to Oracle table. To accomplish this, I have designed the Alteryx workflow as below:

Steps Performed:

1. Discard unwanted text from StartDate and EndDate column string.

2. Convert string fields(StartDate,EndDate) into DateTime and fields(FromDate, ToDate) into Date format with the use of DateTime Parse tool

3. Use Formula Tool to convert the Date and DateTime fields into the required format.

I am also attaching the above  Alteryx workbook for the reference. 

Any help would be appreciated

Thanks,

Rahul

Sample.yxmd

JosephSerpis

Hi @rahuldale those fields will be string fields within Alteryx. If they are in the correct format for Oracle to be recognised as dates and you are inserting to existing table with those columns defined at Date data types then they should remain as date data types in oracle, when you insert the new data. What you need to remember the data types within Alteryx may not necessarily marry up 100% of the time with databases particularity when its around dates. Alteryx only recognises YYYY-MM-DD as a valid date format hence why your fields need to be converted to a string, when you are within Alteryx. However other environments such as Oracle can recognise other date formats.