Date Conversion

The dates in this file are formatted in some custom format and when i try converting it nothing works it just changes to null.

Solutions Attempted:

1) Using the select tool to manually change the date

2) I used the following formula --> DateTimeParse([Raw Date], "%b %d %Y")

Please see attached for the example - any help would be greatly appreciated.

I have include a formula to check for date differences - hopefully the formula will work after the update.

Custom Tools

Date Time

Data Investigation

Accepted answers

Hi, @jonathanzadeh

The workflow is attached.

Cheers!

DateTimeDiff.yxzp

All comments

Hi @jonathanzadeh ,

What format are you wanting the dates to be in? The standard Alteryx format for dates of yyyy-MM-dd (e.g. 2019-12-31) or a custom format Mon dd yyyy (e.g. Dec 31 2019)? Either way I think the DateTime tool will help you immensely, but want to understand what you're trying to achieve so I can build out an example for you.

Hi, @jonathanzadeh

1. Date Time calculations need Date Time Type (use the DateTime Parse Tool to convert from text to DateTime)

2. Proper argument is DateTimeDiff([Maturity_Date],[Price_Date],'duration'), where duration can be any measure of time (days, months, minutes, etc.,)

Please mark the below as a solution + like, if this works for you.

DateTime config example

Formula Tool argument

Cheers!

In the MM/DD/YYYY format.

I would like to use the date time diff formula as well.

Hence, it should be 12/31/19 minus 12/28/19 equal to 3

Would you be able to provide a YXZP using my example with your resolution?

Not sure i follow it

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703