Answered

SharePoint LIst - Date Format Month and Year

(0) Share

Report

Posted on by VeeLearnMSFT

508

One of my SharePoint columns is a date input. It has to be in the Month and Year format, this column specifically. So I want the user only to be able to input lets say, for the sake of an example. January 2022. I noticed that this column has a calculated field. Do I somehow do it in there? and do a =text(Contract End Date,"MMMM YYYY") . Thanks.

Categories:

Building flows

I have the same question (0)

All responses (4)

Answers (2)

Verified answer

Shuvam-rpa 891 Super User 2024 Season 1 on at

Like (0)

Report

@VeeLearnMSFT Yes you can achieve this using calculate column

If this reply has answered your question or solved your issue, please mark this question as answered. Answered questions helps users in the future who may have the same issue or question quickly find a resolution via search. If you liked my response, please consider giving it a thumbs up. THANKS!

Was this reply helpful? Yes No
VeeLearnMSFT 508 on at

Like (0)

Report

The formula does not seem to work inside of the screenshot window above. can you teach me how to do this?

Was this reply helpful? Yes No
Shuvam-rpa 891 Super User 2024 Season 1 on at

Like (0)

Report

@VeeLearnMSFT not there , just make other calculate column where it change the dateformat

Was this reply helpful? Yes No
Verified answer

Community Power Pla... on at

Like (0)

Report

Something else you could try is to leave this column as a String and format the date in this column through Power Automate.
See here: https://docs.microsoft.com/en-us/troubleshoot/power-platform/power-automate/how-to-customize-or-format-date-and-time-values-in-flow

Was this reply helpful? Yes No