Convert date into "General" Format

Question

Hi,

I'm excited to be volunteering here today.

Could you please help me for Change date into "General" Format in Alteryx.

For Example :-

Excel: - A1 is unique ID (1234) and B1 is 08/10/2024 (Today's date)

Excel formula :- =Concat(A1,"-",B1)

Result :- 1234-45514

Note :- 45514 is "General format.

I tried the concat formula in Alteryx but my result is not showing what requirement

Ex :- [ClosureID]+"-"+[Completed]

The result should be "Result :- 1234-45514"

Thank you in advance for your help! I appreciate the time and effort from everyone in the community.

flying008 · Accepted Answer

Hi, @Anilkumar5

FYI.

'- ' + ToString([ClosureID]) + ToString(DateTimeDiff('1899-12-30', DateTimeParse([Completed],'%m/%d/%Y'),'day'))

Anilkumar5 · Accepted Answer

Thank you so much for reply☺

I am unclear on what you replied !

I tried below formula (what you replied) but it doesn't work and result is showing as "- 1234"

'- ' + ToString([ClosureID]) + ToString(DateTimeDiff('1899-12-30', DateTimeParse([Completed],'%m/%d/%Y'),'day'))

Can please explain what is wrong with this and how can be correct it ?

Anilkumar5 · Accepted Answer

You really Awesome !

I got 100% result. We need to insert "DateTime" between input and formula then it will work.

Thank you so much

I am really grateful for your assistance. Your input was invaluable !

May i know What is the format for " 1899-12-30 " ?

flying008 · Accepted Answer

Hi, @Anilkumar5

The date '1899-10-30' is start day for number of Date-time format.

*****************

If can help you get your want, please mark it as a solution for more share.