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
MarkShnier__You
Qrew Legend
Qrew Legendis [Log in number] just a field on the record?
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
Yes Login Number is just a filed on the record.
------------------------------
Raymond Marlon Tiangco
------------------------------
------------------------------
Raymond Marlon Tiangco
------------------------------
- MarkShnier__You
Try this
var text MyDate = ToDate([My Date / Time field]);
var text YY = Right(ToText(Year($My Date));
var text MM = PadLeft(ToText(Month($My Date)),2, "0");
List("", $YY, $MM, ToText([Login Number]))
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------Hi @Mark Shnier,
Is this the formula I should write in the Rich Text Field?
is "My Date / Time Field" a certain field name?
How about "My Date"?
Because my field name is "Quote Date & Time Processed"
May i know how am I supposed to type the formula? since I'm getting an error message "Formula Syntax Error"
Please advise.
------------------------------
Raymond Marlon Tiangco
------------------------------- MarkShnier__Youraymond
This would be a formula text field.
var text MyDate = ToDate([Quote Date & Time Processed]);
var text YY = Right(ToText(Year($My Date));
var text MM = PadLeft(ToText(Month($My Date)),2, "0");
List("", $YY, $MM, ToText([Login Number]))
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------
