Return to Answer

UPDATED: I deleted my previous answer because I realized I had included the "minutes" portion incorrectly. Sorry for any confusion, I'm still new here.

This solution uses a "helper" TimeZone column. So you will need to select a time zone for each item uploaded. The TimeZone column is a choice column with the time zone choices (i.e. Pacific, Mountain, Central, Eastern, whatever you want).

Next, create a CalDate calculated column with the following formula, which uses the default Created column to pull the date values with the following formula:

=CONCATENATE(TEXT(Created,"dd"),TEXT(Created,"hmm"),LEFT(TimeZone,1),TEXT(Created,"mmm"),TEXT(Created,"yy"))

And here is the result:

UPDATED: I deleted my previous answer because I realized I had included the "minutes" portion incorrectly. Sorry for any confusion, I'm still new here.

This solution uses a "helper" TimeZone column. So you will need to select a time zone for each item uploaded. The TimeZone column is a choice column with the time zone choices (i.e. Pacific, Mountain, Central, Eastern, whatever you want).

Next, create a CalDate calculated column with the following formula, which uses the default Created column to pull the date values with the following formula:

=CONCATENATE(TEXT(Created,"dd"),TEXT(Created,"hmm"),LEFT(TimeZone,1),TEXT(Created,"mmm"),TEXT(Created,"yy"))

And here is the result:

And you can change the month to all uppercase by using this formula:

=CONCATENATE(TEXT(Created,"dd"),TEXT(Created,"hmm"),LEFT(TimeZone,1),UPPER(TEXT(Created,"mmm")),TEXT(Created,"yy"))

UPDATED: I just realized you don't need to have the TimeZoneCalc column, as you can just include the LEFT function right in the CalDate column like so:

=CONCATENATE(TEXT(Created,"DD"),TEXT(Created,"HH"),TEXT(Created,"mm"),LEFT([TimeZone],1),TEXT(Created,"MMM"),TEXT(Created,"YY"))

And here's the result:

This solution uses "helper" TimeZone and TimeZoneCalc columns. So you will need to select a time zone for each item uploaded. The TimeZone column is a choice column with the time zone choices (i.e. Pacific, Mountain, Central, Eastern, whatever you want). The TimeZoneCalc column is a calculated column that gets the first letter in the TimeZone column using this formula: =LEFT([TimeZone],1).

Next, create a CalDate calculated column with the following formula, which uses the default Created column to pull the date values:

=CONCATENATE(TEXT(Created,"DD"),TEXT(Created,"HH"),TEXT(Created,"mm"),TimeZoneCalc,TEXT(Created,"MMM"),TEXT(Created,"YY"))

This results in the format you're looking for:

UPDATED: I deleted my previous answer because I realized I had included the "minutes" portion incorrectly. Sorry for any confusion, I'm still new here.

This solution uses a "helper" TimeZone column. So you will need to select a time zone for each item uploaded. The TimeZone column is a choice column with the time zone choices (i.e. Pacific, Mountain, Central, Eastern, whatever you want).

Next, create a CalDate calculated column with the following formula, which uses the default Created column to pull the date values with the following formula:

=CONCATENATE(TEXT(Created,"dd"),TEXT(Created,"hmm"),LEFT(TimeZone,1),TEXT(Created,"mmm"),TEXT(Created,"yy"))

And here is the result:

This solution uses "helper" TimeZone and TimeZoneCalc columns. So you will need to select a time zone for each item uploaded. The TimeZone column is a choice column with the time zone choices (i.e. Pacific, Mountain, Central, Eastern, whatever you want). The TimeZoneCalc column is a calculated column that gets the first letter in the TimeZone column using this formula: =LEFT([TimeZone],1).

Next, create a CalDate calculated column with the following formula, which uses the default Created column to pull the date values:

=CONCATENATE(TEXT(Created,"DD"),TEXT(Created,"HH"),TEXT(Created,"mm"),TimeZoneCalc,TEXT(Created,"MMM"),TEXT(Created,"YY"))

This results in the format you're looking for:

UPDATED: I just realized you don't need to have the TimeZoneCalc column, as you can just include the LEFT function right in the CalDate column like so:

=CONCATENATE(TEXT(Created,"DD"),TEXT(Created,"HH"),TEXT(Created,"mm"),LEFT([TimeZone],1),TEXT(Created,"MMM"),TEXT(Created,"YY"))

And here's the result:

This solution uses "helper" TimeZone and TimeZoneCalc columns. So you will need to select a time zone for each item uploaded. The TimeZone column is a choice column with the time zone choices (i.e. Pacific, Mountain, Central, Eastern, whatever you want). The TimeZoneCalc column is a calculated column that gets the first letter in the TimeZone column using this formula: =LEFT([TimeZone],1).

Next, create a CalDate calculated column with the following formula, which uses the default Created column to pull the date values:

=CONCATENATE(TEXT(Created,"DD"),TEXT(Created,"HH"),TEXT(Created,"mm"),TimeZoneCalc,TEXT(Created,"MMM"),TEXT(Created,"YY"))

This results in the format you're looking for: