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.
Qrew LegendHi @Mark Shnier
I try to use this formula but i'm still getting Syntax Error.
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]))
Just to explain further.
I have a field named Quote Date & Time Processed, which is a Date / Time field type (example: 03-23-2022 03:30 PM)
And I have another field name Quote No., which will be my formula text field that would need the formula that would show 2203003 based on the data of the Quote Date & Time Processed, where 22 = based on 2022 year, 03 = month of March, 003 = based on the Record ID# in QuickBase so if it is Record ID# 1 it becomes 001 if it is Record ID# 24 it should be 024
Will you be able to help create the correct formulas?
Thanks for your help.
