Generate Formula

Use our Google Custom Search for best site search results.

Last post 06-24-2019 08:49 AM by lucky4anshh. 2 replies.

Page 1 of 1 (3 items)
	Sort Posts: Previous Next

06-24-2019 07:54 AM

lucky4anshh
Joined on 04-04-2019
Posts 10

Generate Formula

Reply Contact

I want to use the below formula with concat. I want to add a field before it and then the substring formula. If you could help creating it for me? substring(translate(now(), "_-:T", ""), 3, 5)

06-24-2019 08:43 AM In reply to

Hilary Stoupa
Joined on 06-20-2008
Posts 12,996

Re: Generate Formula

Mark as Not Answer Mark as Answer ...

Reply Contact

concat(YourFieldHere, substring(translate(now(), "_-:T", ""), 3, 5))

Hilary Stoupa

06-24-2019 08:49 AM In reply to

lucky4anshh
Joined on 04-04-2019
Posts 10

Re: Generate Formula

Mark as Not Answer Mark as Answer ...

Reply Contact

Worked... Thanks :D

Page 1 of 1 (3 items)