Date formatting issue

[joshikalyani]

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

[DataNath · Accepted solution]

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 solution]

Hi @joshikalyani 

One way of doing this.

Many thanks

Shanker V

[ShankerV · Accepted solution]

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 solution]

Hi @joshikalyani 

Step 4: Select tool

Many thanks

Shanker V

[binuacs · Accepted solution]

@joshikalyani One way of doing this