Date as String - How to convert to Date

brendafos

I've spent some time reading other posts but I've not quite gotten the answer I need.....

The incoming data has a field type v_string which looks like 5/8/2015 -- I need to convert this to a type date.

I tried the Select tool changing v_string to date but that just outputs 'null's.

I tried -

DateTimeParse(
REGEX_Replace([Text], "([a-z]{3})\s*([0-9]{1}),","$1 0$2,"),
"%b %d,%Y")

But that gives 'null' and does not give an error.

string to date type.png

Can I use DateTimeParse with a string type?

Or how is the best way to approach this?

Regex

Date Time

Accepted answers

JohnJPS

The following worked OK for me:

DateTimeParse([dt],"%m/%d/%Y")

Tested successfull on:

1/1/2001
1/11/2001
11/1/2001
11/11/2001

s_pichaipillai

@brendafos

try DateTimeparse([Field1],'%m/%d/%Y') using formula tool

All comments

jdunkerley79

You need a leading zero on the day as well try:

DateTimeParse(
  RIGHT("0" + REGEX_Replace([Text], "([a-z]{3})\s*([0-9]{1}),","$1 0$2,"), 10),
  "%b %d,%Y")

brendafos

And... I already tried to use the Parse - DateTime conversion tool.

but it seems to do nothing - I put a Select after and it still show data type as v_string

NickJ

Hi there,

Attached is a tiny workflow that takes a 'date' as a V_String and uses DateTimeParse to convert to a 'real' date (liberties taken on whether the month is May or August!)

Hope this helps?

Cheers,

Nick

- Solutions Engineer

DateTimeParse from VString.yxmd

JohnJPS

The following worked OK for me:

DateTimeParse([dt],"%m/%d/%Y")

Tested successfull on:

1/1/2001
1/11/2001
11/1/2001
11/11/2001

s_pichaipillai

@brendafos

try DateTimeparse([Field1],'%m/%d/%Y') using formula tool

brendafos

Thank you.

I tried you addition... but I still just get nulls

string to date type v2.png

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703