Forum Discussion

Arnie_Howes's avatar
Arnie_Howes
Brass Contributor
Jul 18, 2024

SharePoint Calculated Column Refuses to Return a Correct Date!

This is frustrating! So many things have quit working in SharePoint!

Here's the latest - it worked fine for years and now it doesn't:

=[Last Review Date] + [Review Frequency]

(Last Review Date is a date field; Review Frequency is a number such as 90)

It returns all dates as 1900! I've never had this problem before. I've tried all the workarounds suggested by CoPilot, but none work. Is this just another of the string of temporarily not-working functions in 365? This has been a very trying month, MSFT!

Thanks so much for any help you can give 🙂

SharePoint Online
  • Expiscornovus's avatar
    Expiscornovus
    Iron Contributor
    Jul 18, 2024

    Arnie_Howes what is the setup of your fields. I assume the Last Review Date is date only? Or are you also using a time? And is the number field without decimals?

     

    Have you also tried this formula, just to see if that makes a difference?

    =DATE(YEAR([Last Review Date]),MONTH([Last Review Date]),DAY([Last Review Date])+[Review Frequency])

     

     

Resources