Convert excel formula to Alteryx fomate

Question

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 Answer

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.