+- Community | RoboIntern (https://robointern.tech/community)
+-- Forum: RoboIntern Forum (https://robointern.tech/community/forumdisplay.php?fid=1)
+--- Forum: How To / Q&A (https://robointern.tech/community/forumdisplay.php?fid=2)
+--- Thread: Dynamic Date/Time in Subject of Mail (/showthread.php?tid=4)
Dynamic Date/Time in Subject of Mail - bkar81 - 06-10-2019
First and foremost, I have to say, a ton thanks to RoboIntern team for this awesome app.
While trying out dynamic texting in the Subject line, I tried the below to include the current date and time, but I am getting only the date with 00:00 as time.
="Report refreshed at " & TEXT(TODAY(),"MM-DD-YYYY hh:mm")
Please let me know what to put to include the time as well.
Thank you,
BK
RE: Dynamic Date/Time in Subject of Mail - RoboIntern - 06-11-2019
Hi bkar81,
Many thanks for your post, glad to hear you're enjoying the app!
Well, fixing that should be easy, use the NOW() formula instead in TODAY(), just like in Excel:
="Report refreshed at " & TEXT(NOW(),"MM-DD-YYYY hh:mm")
Have a nice day,
Tom
RE: Dynamic Date/Time in Subject of Mail - bkar81 - 06-12-2019
It worked like a charm. Thank you.
What kind of dynamic strings can be used - will it allow all/most of the Excel formula?
RE: Dynamic Date/Time in Subject of Mail - RoboIntern - 06-12-2019
Great
I tried to cover most time related ones from Excel - the currently supported ones are as below:
NOW, TODAY, WEEKDAY, WORKDAY, DAY, MONTH, YEAR, EOMONTH, DATE and TEXT
If you have suggestions for new ones feel free to let me know, I can include them in the app