Validate date file format using awk

Shell Programming and Scripting
1

Here is my sample data
Test.txt

column 1|columne 2|start Date|end Date
test|test|03/24/2014|03/24/2014
test|test|03/24-2014|03/24/2014
test|test|03/24/2014|03/24/2014
test|test|03/24/2014|03/24-2014
test|test|03/24/2014|03/24/2014

Now in the file i am expecting the date fields should be mm/dd/yyyy format.
How i can validate without open the file data row number 2 and 4 having wrong date format and print the data rows.

2

Hello,

Kindly use the coede tage as per forum rules for any command or code please.
Following may help you for same.

awk  -F"\|" 'BEGIN {print "Showing lines which have issues."} {a=match($3,/..\/..\/.....*/); substr($3,RSTART,RLENGTH)} {if(a==0) {print $0}} {b=match($4,/..\/..\/.....*/); substr($4,RSTART,RLENGTH)} {if(b==0) {print $0}}' check_date_format1211134

Output will be as follows.

test|test|03/24-2014|03/24/2014
test|test|03/24/2014|03/24-2014

NOTE: Where check_date_format1211134 is the input file.

Thanks,
R. Singh

3 
awk -F'|' -v OFS='|' ' $3 !~ "^(0[1-9]|1[12])/(0[1-9]|[12][0-9]|3[01])/[0-9]{4}$" || $4 !~ "^(0[1-9]|1[12])/(0[1-9]|[12][0-9]|3[01])/[0-9]{4}$" ' file
4

Thanks RavinderSingh13 and anbu23

5 
awk -F "|" '{match($3FS$4,/..\/..\/....\|..\/..\/..../);printf RSTART==0?$0"\n":x}'  filename