Displaying Date field dates without dashes

Question

I want to generate a good that looks like this:

REQ##-YYYYMMDD-######
where
REQ[Record ID#]-[From a Date Field]-[From a number field]
e.g.:
REQ12-20210218-123456

The formula I used in the formula field is:

"REQ"&[Record ID#]&"-"&ToFormattedText([Date Received],"YYYYMMDD")&"-"&[Source ID]

It displays as:

REQ12-2021-02-18-123456

Close, but I would like to remove the dashes in the date field. How can I do this?

------------------------------
Paul Easton
------------------------------

blakeharrison · Answer

Rather than using the 'Part' function against a date field, you can use 'Month', 'Day', and 'Year'. I'd do something like this:
var number y = Year([Date Received]);
var text m = Right(ToText(100+Month([Date Received])),2);
var tex d = Right(ToText(100+Day([Date Received])),2);

"REQ" &amp; List("-",[Record ID#],$y &amp; $m &amp; $d,[Source ID] ​------------------------------Blake Harrisonbharrison@datablender.ioDataBlender - Quickbase Solution ProviderAtlanta GA404.800.1702 / http://datablender.io/------------------------------

blakeharrison · Answer

Not in the grand scheme of things, no. Your formula accomplishes the same thing and in just about the same amount of formatting gymnastics. Your use of 'ToFormattedText' and 'Part' is fairly interchangeable with my option to add 100 to the Month/Day, convert it to text, and then pull off the last 2 characters using 'Right'.------------------------------Blake Harrisonbharrison@datablender.ioDataBlender - Quickbase Solution ProviderAtlanta GA404.800.1702 / http://datablender.io/------------------------------

pauleaston · Answer

Okay, this is how I got it to work:&nbsp;"REQ"&amp;[Record ID#]&amp;"-"&amp;Part(ToFormattedText([Date Received],"YYYYMMDD"),1,"-")&amp;Part(ToFormattedText([Date Received],"YYYYMMDD"),2,"-")&amp;Part(ToFormattedText([Date Received],"YYYYMMDD"),-1,"-")&amp;"-"&amp;[Source ID]Probably a more elegant way to accomplish this, but this works.------------------------------Paul Easton------------------------------

pauleaston · Answer

Thank you Blake.&nbsp; Is there any disadvantage to use part, besides it being a bit of kludge?&nbsp; Any performance impacts?&nbsp; Just curious.------------------------------Paul Easton------------------------------

Forum Discussion

Displaying Date field dates without dashes

Related Content

Display Thumbnail Image

New Form Button display settings

Form rule modal display a link

Form Rule "Show Report" displays No options

Reference Numbers Displaying Instead of Names in QuickBase