I have a date field, and it has the date in the format - 11/2/2011 11:40 AM

How ever my requirement is to get the date in the format - 02 Nov 2011 11:40 AM

For that I created a calculated field for the said field and used the formula as - =TEXT(Modified,"dd mmm yyyy hh:mm ")

It resulted in the following date format - 02 Nov 2011 11:40 (It is a 24 hour format).

Now my question is how can I edit the formula to get the time in 12 hour format.

1 Answer 1


I believe the date/time format you are looking for is:

"dd mmm yyyy h:mm AM/PM"

This may be useful: TEXT function reference


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

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