0

I am trying to use a calculated column to generate something like this using [Created]: 161000TAPR15

16=Day of the Week, 10=Hour, 00=Minutes, T=[TimeZone],First letter of the Time Zone, APR=Month, 15=Year,

I've tried various combinations and nothing seems to work. Please help!

1
  • 1
    Is your Day, Hour, Minutes, TimeZone, etc. all in different columns? Or do you want to take the default "Created" field and format it like 161000TAPR15?
    – clk
    Aug 6 '15 at 20:06
1

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:

The results

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"))

with uppercase

0
1

This is shorter and easier to read:

=UPPER(REPLACE(TEXT(Created,"ddhhmmTZmmmyy"),7,2,LEFT(TimeZone))
  • SharePoint REPLACE (alas) needs a start and length parameter
    TZ starts at character 7 and is 2 characters long
  • LEFT() takes 1 character by default

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.