Date Time Tool-Input

[kaverijaiswal]

Hello Members,

Hope you all are safe and healthy.

I want to utilize my quarantine time, learning Alteryx tool and getting the designer certificate.

As I was going through all the tools functionality on the canvas, I was not able to find out which input tool we should be using when we select Date Time tool. I noticed there is only output node for this which confused me on how to input data into this.

I would appreciate if anyone can guide and help me to understand the usage.

Thanks,

Kaveri Jaiswal

[T_Willins · Accepted solution]

Hi @kaverijaiswal,

The DateTime tool should have an input anchor.  The tool is used to convert dates and times in strings to Alteryx DateTime format or convert DateTime fields to string fields or extract information from DateTime fields.  Here is a link to the tool documentation:  https://help.alteryx.com/2020.1/DateTime.htm 

[AbhilashR]

Hi @kaverijaiswal - you use the DateTimeTool when attempt to convert string field to date, or date field to string. It gives you many options to setup your logic, most of which is self explanatory. Take a look at the attached link to get a better understanding of this tool:

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-DateTime/ta-p/38302

[kaverijaiswal]

Hi Abhilash,

Thanks for responding.

 I would like to share the screenshot of the date time tool which seems to be a bit different. May be I am using the wrong one.

[AbhilashR · Accepted solution]

Hi @kaverijaiswal, the tool you highlighted just gives you current date time, the tool we were referring to is in the image below. I have also included a sample solution to help you understand its usage.

 

You should also bookmark this page as you go through your Alteryx journey:

https://community.alteryx.com/t5/Alteryx-Designer-Knowledge-Base/Tool-Mastery-Index/ta-p/84593

[kaverijaiswal]

Understood. This helped a lot!!!

Thanks again!

Kaveri Jaiswal

[kaverijaiswal]

Thanks a lot for your help here.

Best Regards,

Kaveri Jaiswal

[AbhilashR]

Please mark this post as solution accepted if it answered your question.