Convert excel formula to Alteryx fomate

[JanaZ]

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

[flying008 · Accepted 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.

[JanaZ]

Thanks @flying008