Hi @Don Larson,
Good day!
Thank you for helping me with my ticket number formula. But I'm getting a Formula Syntax Error stating "The argument list of the function NumRID must begin with a left parenthesis."
Below is the one I entered in the formula as you stated.
var text NumMonth = If(Month(ToDate([Date & Time Processed]))<10, "0" & Month(ToDate([Date & Time Processed])), Month(ToDate([Date & Time Processed])));
var text NumDay = If(Day(ToDate([Date & Time Processed]))<10, "0" & Day(ToDate([Date & Time Processed])), Day(ToDate([Date & Time Processed])));
var text NumYear = ToText(Year(ToDate([Date & Time Processed])));
var text NumYear = ToText(Year(ToDate([Date & Time Processed])));
var text Ticket = $NumMonth & $NumDay & $NumYear & NumRID;
$Ticket
When I added a add a parenthesis in before the NumRID, I get this Syntax Error "An identifier must follow the type in a variable declaration."
var text NumMonth = If(Month(ToDate([Date & Time Processed]))<10, "0" & Month(ToDate([Date & Time Processed])), Month(ToDate([Date & Time Processed])));
var text NumDay = If(Day(ToDate([Date & Time Processed]))<10, "0" & Day(ToDate([Date & Time Processed])), Day(ToDate([Date & Time Processed])));
var text NumYear = ToText(Year(ToDate([Date & Time Processed])));
var text (NumRID = ToText([Record ID#]);
var text Ticket = $NumMonth & $NumDay & $NumYear & NumRID;
$Ticket
Please advise. Thanks!
------------------------------
Raymond Marlon
------------------------------