Forum Discussion

Brass Contributor

Nov 05, 2018

Solved

Sharepoint calculated column if date greater than another column

Hi guys, I have two fields on my Sharepoint list. One of them is called 'From Date' and another one called 'To Date'. How do I create a formula that validates if To Date is greater than From Dat...

Rafael Benicio
Nov 06, 2018
Hey Matt Weston,

I thought it was working but it's not! Just noticed, the validation is not working properly.

The formula that works is this one =[To Date]>=[From Date].

Rafael Benicio

Brass Contributor

Nov 06, 2018

Hi Matt Weston,

Thank you for your reply. Unfortunately, The formula below didn't work.

IF([To Date]>[From Date],"Date Greater Than","Date Less Than")

Here is the error message:

Rafael Benicio

Brass Contributor

Nov 06, 2018

Matt Weston Never mind, I put the formula in the validation settings under list settings and it worked.

Thank you so much! Cheers!

Rafael Benicio
Brass Contributor
Nov 06, 2018
Hey Matt Weston,

I thought it was working but it's not! Just noticed, the validation is not working properly.

The formula that works is this one =[To Date]>=[From Date].
- Matt Weston
  Iron Contributor
  Nov 07, 2018
  Hi Rafael Benicio, yes that is how the formula would be for list validation. Apologies, the original formula I gave you was for a calculated column.
  - CharlesDK
    Copper Contributor
    May 27, 2020
    Hi Matt Weston
    
    I am getting an error message for the same formula (different column names)
    
    =[End Date of Action]>=[Start Date of Action]
    
    Error:
    Sorry, something went wrong
    The formula cannot refer to another column. Check the formula for spelling mistakes or update the formula to reference only this column.
    
    Do you have a suggestion as to what the solution is?
    
    Many thanks!