Updating the Slash to decimal point in the date

[Vishal_95]

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

Can someone suggest a solution

[dougperez]

Convert to string and replace it

[binay2448]

Find attached Solution..

[atcodedog05 · Accepted solution]

Hi @Vishal_95 

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

Workflow:

Hope this helps : )

[RolandSchubert · Accepted solution]

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]

 Hi atcodedog05,

Thank you for the Input it worked.

[atcodedog05]

Happy to help : ) @Vishal_95 

Cheers and have a nice day!