• 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Dynamic Date/Time in Subject of Mail
#1
Thumbs Up 
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
  Reply
#2
Hi bkar81,

Many thanks for your post, glad to hear you're enjoying the app! Smile

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
  Reply
#3
It worked like a charm. Thank you.

What kind of dynamic strings can be used - will it allow all/most of the Excel formula?
  Reply
#4
Great Smile

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
  Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)