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...
var date MyDate = ToDate([Quote Date & Time Processed]); var text YY = Right(ToText(Year($MYDate)), 2); var text MM = PadLeft(ToText(Month($MyDate)),2, "0");
List("", $YY, $MM, ToText([Record ID#]))
------------------------------ Mark Shnier (YQC) mark.shnier@gmail.com ------------------------------