Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

Updating the Slash to decimal point in the date

Vishal_95
7 - Meteor

Hi All,

I am trying to update the date format in the workflow by removing the slash(/) to decimal point(.). The data type is Date

Vishal_95_0-1631547357655.png

Can someone suggest a solution

 

6 REPLIES 6
dougperez
12 - Quasar

Convert to string and replace it

binay2448
11 - Bolide

Find attached Solution..

atcodedog05
22 - Nova
22 - Nova

Hi @Vishal_95 

 

Since you said its date datatype. Here is how you can do it.

Workflow:

atcodedog05_0-1631548295031.png

 

Hope this helps : )

 

RolandSchubert
16 - Nebula
16 - Nebula

Hi @Vishal_95 ,

 

if I got you right, the data type in Alteryx is Date (representated in Excel as "dd/mm/yyyy") and you want to create a format "dd.mm.yyyy" in Excel?

 

You can use the DateTimeFormat funtion to convert the date data type to a string data type in the required format. DateTimeFormat([DateField], '%d.%m.%Y') should do the job.

 

Let me know if it works for you.

 

Best,

 

Roland 

Vishal_95
7 - Meteor

 Hi atcodedog05,

 

Thank you for the Input it worked.

atcodedog05
22 - Nova
22 - Nova

Happy to help : ) @Vishal_95 

Cheers and have a nice day!

Labels