Dynamic Date/Time in Subject of Mail

[bkar81]

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

[RoboIntern]

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

[bkar81]

It worked like a charm. Thank you.

What kind of dynamic strings can be used - will it allow all/most of the Excel formula?

[RoboIntern]

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