Answered

DateTime Display in SharePoint Calculated Column

(0) Share

Report

Posted on by Phineas

5,331 Moderator

I am practicing.

I have a SharePoint list. The DateTime and FullName columns are being populated by a Patch.

The 'TimeStampAuthor' is the calculated column in which I want the combined.

I've got the data coming in but I'd like the data and time to appear in the 'TimeStampAuthor' calculated columns as appears in the 'Title' column (data manually entered) shown, rather than as a numeric value.

SharePoint Columns
TimeStampAuthor (Calculated Formula): =DateTimeOfEntry&"; "&SenderFullName
DateTimeOfEntry Type = DateTime (with time)
FullName Type = Single-line of text

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (1)

Verified answer

rb 835 Super User 2024 Season 1 on at

Like (1)

Report
Copy link

Link copied!
In your calculated column, can you use this?
TEXT([DateTimeOfEntry],"D/M/YYYY")&"; "&SenderFullName
I have not tested this, but I followed steps from here: https://natechamberlain.com/2018/08/27/extract-date-components-using-the-text-function-in-sharepoint-calculated-columns/

Was this reply helpful? Yes No
Phineas 5,331 Moderator on at

Like (0)

Report
Copy link

Link copied!

If the month is more than one digit what happens? Even though there is only 'd' will it adjust from '9' to '10'?

I updated to dd, but I think this confuses things, as it can look like 08/08/2022; "Are the first two day or month...", they'll ask.

Was this reply helpful? Yes No
rb 835 Super User 2024 Season 1 on at

Like (0)

Report
Copy link

Link copied!
Single format part will just use the current value (eg 'M' = 1, 2, 3, 4, 5, 6, 7, 8, 9, 10, 11 or 12)
Two format parts will use the current value padded with zeros (eg 'MM' = 01, 02, 03, 04, 05, 06, 07, 08, 09, 10, 11 or 12)

Some ways you can avoid confusion are:
Use 'MMM' for month, which will be 'Jan', 'Feb', 'Mar' etc.
Eg 'd/MMM/yyyy' = '30/Jul/2022'
Eg 'MMM dd yyyy' = 'Jul 30 2022'
Use 'yyyy-mm-dd' = '2022-07-30'

Was this reply helpful? Yes No