Date formatting issue

Question

I'm facing issue for date format, If in  column, dates are in different format how to convert that into same format

DataNath · Accepted Answer

Hey @joshikalyani, here's one way you could handle this:

As some of your dates are already in the correct format, we just need to convert those that aren't. The field is currently in string format so we can check for problem entries by checking whether ToDate() produces a null. If so, that means the record needs to be made into a Date which is when we bring in DateTimeParse() for the conversion.

ShankerV · Accepted Answer

Hi @joshikalyani

One way of doing this.

Many thanks

Shanker V

ShankerV · Accepted Answer

Hi @joshikalyani

Step 1: Input

Step 2:

Step 3:

IF IsNull([DateTime_Out])
THEN [Field1]
ELSE [DateTime_Out]
ENDIF

Many thanks

Shanker V

ShankerV · Accepted Answer

Hi @joshikalyani

Step 4: Select tool

Many thanks

Shanker V

binu_acs · Accepted Answer

@joshikalyani One way of doing this