• Rakesh Kumar 378
  • NEWBIE
  • 0 Points
  • Member since 2017

  • Chatter
    Feed
  • 0
    Best Answers
  • 0
    Likes Received
  • 0
    Likes Given
  • 1
    Questions
  • 1
    Replies


Hi All,

I have a requirement where I need to check the format of a text field like DD/MM but we need to ensure that if we enter 02 as month then it should not allow to use any value above than 28. I am using the below mentioned validation rule and it checks every thing excep the feb month condition

AND( 
NOT(ISBLANK(EarliestStartDate__c)), 
NOT(REGEX( EarliestStartDate__c ,"(0[1-9]|[12][0-9]|3[01])[- /.](0[1-9]|1[012])")) 
)

Kindly suggest
 
Hi Everyone,

I have a text field that I want to start with a date in the dd/mm/yy format.

I am trying to get a REGEX validation rule to force this but I am struggling.

I need the rule to allow dd/mm/yy - *

The* will allow any text afterward.

Would someone be able to tell me the correct expression please?

Thanks
Joe