I have date time column called Today.
I'm trying to create calculated column which check today is 14
Value for Today column is 4/13/2017 I m trying to check that is today is 14. means like this (4/14/2017)
SharePoint Stack Exchange is a question and answer site for SharePoint enthusiasts. It only takes a minute to sign up.Sign up to join this community
Remember that SharePoint is NOT Excel, so Formulas do not update Date calculations
=DAY( [DateTime] )
gets you the day number
=IF( DAY( [DateTime] )=14 , "It is the 14th" , "Not the 14th" )