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
You could create two fields to extract the year and month similar to:
Formula Text fields:
Year Date:
ToText(Right(Year([Date Field]), 2))
Month Date:
PadLeft(ToText(Month([Date Field])), 2, "0")
then in your log field:
var text formulaQuery = "{FID1.EX.'" & [Year Date] & "'} AND {FID2.EX.'" & [Month Date] & "'} AND {3.LTE.'" & [Record ID#] & "'}";
[Year Date] & [Month Date] & PadLeft(ToText(Size(GetRecords($formulaquery))), 5, "0")
where FID1 is the field ID of the year date field and FID2 is the field ID for the month date field
------------------------------
Paul Peterson
------------------------------
Formula Text fields:
Year Date:
ToText(Right(Year([Date Field]), 2))
Month Date:
PadLeft(ToText(Month([Date Field])), 2, "0")
then in your log field:
var text formulaQuery = "{FID1.EX.'" & [Year Date] & "'} AND {FID2.EX.'" & [Month Date] & "'} AND {3.LTE.'" & [Record ID#] & "'}";
[Year Date] & [Month Date] & PadLeft(ToText(Size(GetRecords($formulaquery))), 5, "0")
where FID1 is the field ID of the year date field and FID2 is the field ID for the month date field
------------------------------
Paul Peterson
------------------------------
Hi @Paul Peterson
Hi I'm getting "Formula error -- Bad or missing arguments in function call" message when I tried to use this formulaToText(Right(Year([Date Field]), 2))
in the "Year Date" Formula text field.
Is there another way? Please advise.
------------------------------
Raymond Marlon Tiangco
------------------------------- MarkShnier__You
Qrew Legend
The Year function returns a number so you need to convert it to text first.
Right(ToText(Year([Date Field])), 2)
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------ - MarkShnier__You@Raymond Marlon Tiangco
Try this
Right(ToText(Year([Date Field])), 2)
------------------------------
Mark Shnier (YQC)
mark.shnier@gmail.com
------------------------------- Hi @Mark Shnier
I tried the changes you mentioned, but I'm still getting Syntax Error message
var text MyDate = ToDate([Quote Date & Time Processed]);
var text YY = Right(ToText(Year([Quote Date & Time Processed])), 2)
var text MM = PadLeft(ToText(Month($My Date)),2, "0");
List("", $YY, $MM, ToText([Record ID#]))
Kindly advise.
------------------------------
Raymond Marlon Tiangco
------------------------------
