Skip to main content

Date type parameter validation

Comments

2 comments

  • Meenakshi Motwani

    This is helpful. How can we also have sequence of dates correct in the same formula ?

    Like not allowing below date sequence 

    Start date 15th Dec 2020 

    End date 15th Nov 2020 

     

    0
  • Cindy Liu

    Thanks for the comments. Actually the formula function DateDiff(intervalType, startDateTime, endDateTime) already validates the sequence. If the endDateTime variable is smaller, than the function will return negative number instead of positive number.

    0

Please sign in to leave a comment.