Log Number
Hi,
May someone help me create a formula for a Rich Text (Formula) field to be able to create a log number based on a Date / Time field.
Example:
Date / Time = 12-17-2021 1:33 PM
I want m...
Forum Discussion
Hi @Mark Shnier
It worked. Thanks for your help.
Just a follow-up question, if I use the same formula you provided to a different field type for example a Date Type only (ex. Opportunity Date)
var date MyDate = ToDate([Opportunity Date]);
var text YY = Right(ToText(Year($MYDate)), 2);
var text MM = PadLeft(ToText(Month($MyDate)),2, "0");
List("", $YY, $MM, ToText([Record ID#]))
How come I'm getting a another formula error?
May you please advise what should be the new formula?
------------------------------
Raymond Marlon Tiangco
------------------------------
MarkShnier__You
Qrew Legend
Qrew LegendThe Opportunity Date fild is likely already a Date type field. So there is not need to convert it to a Date.
var date MyDate = [Opportunity Date];
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
var date MyDate = [Opportunity Date];
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
- Thank you very much @Mark Shnier! :)
------------------------------
Raymond Marlon Tiangco
------------------------------
