Convert date into "General" Format

[Anilkumar5]

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 solution]

Hi, @Anilkumar5 

FYI.

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

[Anilkumar5 · Accepted solution]

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 solution]

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 solution]

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.