is there any way that i can modify data type in send email format ??
i am trying to change data type for RCP date
Please help…
You can’t change the data type of that field but if you’re in a BPM, you can create a variable that gets the RcvDate and converts it to a DateTime.
1 Like
how to do that??
What I’ve done for such things is to set a variable before the actual EMail, then use that variable (scalar variable for insert purposes) in the EMail. Such as: tExpectedClose = String.Format(“{0:M/d/yyyy}”, Q.ExpectedClose);
then insert tExpectedClose.
1 Like
can you show me how to do it?
i notice
but date received field is coming from another table how to add new variable??
Pls help thanks
Capitalize your M (month)
Lowercase (m) is for minutes
i am trying to add another format for qty so i have to do the same way ?
see screenshot.
Now i get under date received qty field pop up why??
Can you move the solution to @MLamkin ? She’s the one who provided the answer… I just chimed in on the syntax.
… as for the Qty… no idea why that popped in there. Can you just delete it and re-insert the qty table field?
1 Like
I found my mistake thanks
1 Like