Hi All
How can I convert the below excel formula in Alteryx?
=concat(TEXT(TODAY(),"YYYYMMDD"),"_",TEXT(NOW(),"HHMMSS"),"_",row())
I have done the below
DateTimeFormat(DateTimeStart(),'%Y%m%d_%H%M%S')
and add a Record ID
However, I don't know how to put them together.
Thanks
Jana
Solved! Go to Solution.
Hi, @JanaZ
Just for you:
DateTimeFormat(DateTimeNow(),'%Y%m%d_%H%M%S_') + ToString([RecordID])
BTW, you can use DateTimeStart() replace the formula part DateTimeNow() if you need.
******
If it can help you , please mark it as a solution and give a like for more share.
Thanks @flying008