Identify if data is in Date format or string

Hi,

I'm trying to do a formula that says if the date is in string format parse it to become dateformat else if it already in date format leave it as is.

If [first_billing_date] = string then DateTimeParse([first_billing_date],"%m/%d/%Y") else [first_billing_date] endif

something like this

Datasets

Date Time

Accepted answers

ChrisWaspe

Hi @mhtomines . I have expanded your example to include a string value which matches your format. When there is a combination of string and date value the column will be considered a string. You can then use Regular Expression to identify the values which match the string format you are looking for, and apply your formula. You have to create a new column as you can change data types within the formula tool.

Please feel free to reach for more info.

New Workflow4_CW.yxmd

All comments

caltang

I believe the formula below helps you identify if a field is a string or not (T/F).

IsString()

So, you can try:

IF IsString([first_billing_date])
THEN DateTimeParse([first_billing_date],"%m/%d/%Y") 
ELSE [first_billing_date] 
ENDIF

Hope this helps!

Best regards,
Calvin Tang
https://www.linkedin.com/in/calvintangkw/

ArnaldoSandoval

Hi @mhtomines

You got two options.

The Browser Metadata tab, before implementing a formula or
The Field Infor tool

Both approaches allow you to check fields types.

hth

Arnaldo

Raj

Formula tool will help you to achieve this
use Is string formula.

mhtomines

Hi @caltang thank you for your response, however when I filter the date the data won't show up. The column first billing date is not constant "datetime" format sometimes it changes to string depending on the result of data download.

Attached is my workflow

New Workflow4.yxmd

ChrisWaspe

Please feel free to reach for more info.

New Workflow4_CW.yxmd

mhtomines

This works! thank you!!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703