Store cb_date_field_A as formatted date in cb_date_field_B

We have a cb field storing a date value like yyyy-mm-dd that we use for several triggers but I'd also like to store the same date value in a second cb field in a nicer format like j F Y so we can map it to Moodle and print it on PDF certificates.

I've setup a Code field using the following code that accurately grabs the cb_date_field_A and displays it in cb_date_field_B, but the issue is its not actually storing the value in the database, its only displaying it on the backend and frontend user profile. In fact, it doesn't appear that Code fields actually create a table column at all. Is there a way I can accomplish the same goal but have a stored value in the DB that I can then map over to Moodle?

Date, Datetime, and Time fields support custom display formats. You should be able to just change the format directly in your field under Parameters > Display. Next use [FIELD_NAME] when you want SQL formatted (0000-00-00 00:00:00) and use [cb:userfield field="FIELD_NAME" /] when you want it display formatted.

You are correct that Code fields have no storage at all. They simply take your PHP and display it as a field value. They can still be substituted in, but they cannot be queried for.

Is there a way I can accomplish the same goal but have a stored value in the DB that I can then map over to Moodle?

Is there a reason it needs to be stored in the database? You should be able to push data to Moodle using CB Auto Action using substitutions to get field values.