仅在发送电子邮件正文中显示日期
我有一封电子邮件,将发送给服务的请求者.电子邮件将包含列表中的关键字段. 附加到的工作流程设置为在更改时运行.我的电子邮件有2个问题.
I have an email that will be sent to the requester of a service. The email will contain the key fields from the list. The workflow that it is attached to is set to run on change. I am having 2 issues with the email.
1.当我要求日期(例如完成日期)时,我正在获取日期和时间.我的区域设置仅在列表中设置为日期,但是当信息转移到电子邮件中时,我将恢复为日期和时间. 我该如何 最好摆脱时间?对于我来说,日期就足够了.
1. When I call for the date (completion date for example) I am getting the date and time. I have the regional setting set to date only on the list but when the information gets transferred into the email, I am back to date and time. How do I best get rid of the time? In my case, the date is sufficient.
2.当我有一个未填充的日期(例如,取消的日期)时,它将放入1/1/0001 12:00:00 AM.我想将其简单地显示为空白.
2. When I have a date that is not populated (cancelled date for example) it puts in 1/1/0001 12:00:00 AM. I would like to show this as simply a blank.
到目前为止,这是该行在电子邮件正文中的外观:
So far this is how the line looks in the body of the email:
[%当前项目:请求日期%]
我尝试了几件事:
我将工作流程变量设置为日期的左10个字符.我尝试使用公式将日期转换为mm/dd/yyyy(文本(日期,"mm/dd/yyyy")),我尝试在空白日期合并. >
I made a workflow variable set to the left 10 characters of the date. I have tried using a formula to convert the date to mm/dd/yyyy (text(date,"mm/dd/yyyy"), I tried coalesce on the blank date.
我愿意接受任何建议. 我将按原样保留日期,直到得到良好的答复为止,但我想为用户整理一下日期.
I am open to any suggestions. I am going to leave the date as is until I can get a good response, but I would like to make it clean for the user.
Tim Vavra
Tim Vavra
更改" [%Current Item:Request Date%] "从作为字符串"返回为字段到短日期"
Change "Request Date: [%Current Item:Request Date%]" return as field as from "As String" to "Short Date"