PDA

View Full Version : validating the date in vba



mahalatchumi
10-18-2011, 05:29 AM
VBA CODING:


Text = "([0-3][0-9][/.\-]<[A-Za-z]*>[/.\-][0-9]{1,})"

this is my vba coding to highlight the date format, but it highlights "02-march-1998" and it also highlight the "02-magi-7878" . i need the correct code to check the exact day, month and year using msword and vba coding....