I’ve written a script in UiPath to automate sending of emails from data in an excel spreadsheet. For the email body, I’m using this dynamic formula to populate the date for the email [i.e under “Invoice Due”] - String.Format(EmailMessage,row(“Name”).ToString,row(“Invoice Due”).ToString)
When I run the script, I note in the email that the the date format is mm/dd/yyyy hh:mm:ss. How do I change the date format in the email sent to just “dd/mm/yyyy, Day (eg. Tuesday)”?
[The forum doesn’t allow me to add an attachment cos I’m a new user, so I can’t share the UiPath process…]