How to convert Date Time to Date while sending notification within workflow

I am sending the order notification when the order is placed to the customer using workflow notification.
Within the notification I need to send the promise date and this promise date is coming from Sxe Sales Order BOD. Within the BOD promise date is Date and Time field with UTC time, but I want to send only the promise date and not the time. Is there any way I can convert date and time field to date when I send the email notification through the ION workflow?

Find more posts tagged with

ION Workflow

Accepted answers

All comments

Legacy Contributor

Within Workflow there is a "Set Parameter" step. If the Promise Date is passed to the Workflow as a string parameter, then the Set Parameter step has built-in expressions that can be used to extract just the date portion of the string. The new value can then be sent in a notification.

Legacy Contributor

Thanks for your quick response.

I am passing the parameters to workflow with the activation policy. Within AP attributes promise date is date time and not the string. Not sure how do I convert date time to string in this case, to get the date from date time as per your solution above.

Jyoti

Legacy Contributor

I don't believe there is any way to do this within Activation Policies or Workflow. However, you could call an external third party API from a workflow that would convert the date to a string. That is a lot of work though for a simple function. So I have entered an enhancement request for this. Please see ERS.INFOR.COM/.../ERS_DETAILS.ASPX. Feel free to "vote" for this ER to increase its priority and add any other comments you may have.

Legacy Contributor

Thanks for submitting enhancement request for this, I voted for this one.

For the work around do you know any free API I can use to convert DateTime to Date, or DateTime to string?

Regards,

Jyoti

Copyright © 2025 Infor. All rights reserved.