09-07-2012, 01:32 AM
Hello
First find out row count and then start compare each month using IF condition.
Start with December month and start with 31 date.
You want to compare and find highest date ?. You can do using Loop. run loop and change each time value and compare the value.
It is more VB programming part.
First find out row count and then start compare each month using IF condition.
Code:
if month = December then
split that month with dates and compare with each December date.
and exist...
You want to compare and find highest date ?. You can do using Loop. run loop and change each time value and compare the value.
It is more VB programming part.