Find records with matching time/date and other criteria

Find records with matching time/date and other criteria

I have a travel booking application. I wish to check all future bookings to see whether any journeys on the same day also are either starting or ending in the same place. 

I can use the post code field to establish where journeys are starting from and ending - UK post codes are split into two parts and I wish to use the first part only which specifies the general area.

I want to identify all bookings where the journey times are within an hour of each other and where either the origin or the destination matches the first part of the post code.

I have a implemented the following to ensure that the post code is correctly input and formatted:

  1. // Ignore the space and convert the postal code into capitals
  2. ignoreCase = (input.Address_post_code.getAlphaNumeric()).toUpperCase();
  3. // Check with regEx
  4. temp = (ignoreCase).replaceFirst("(GIR 0AA|[A-PR-UWYZ]([0-9]{1,2}|([A-HK-Y][0-9]|[A-HK-Y][0-9]([0-9]|[ABEHMNPRV-Y]))|[0-9][A-HJKPS-UW])[0-9][ABD-HJLNP-UW-Z]{2})","");
  5. if (temp  ==  "")
  6. {
  7. // Get the length of the formatted correct Postal Code      
  8. len = (ignoreCase).length(); 
  9. // Get the second set of the string (ANN format)      
  10. secondSet = (ignoreCase).subString((len  -  3),len); 
  11. // Get the remaining First set of the string      
  12. firstSet = (ignoreCase).subString(0,(len  -  3));
  13. // Alter the postal code to be in Capitals with an empty space between the first set and the second set      
  14. input.Address_post_code = firstSet + " " + secondSet;
  15. }
  16. else
  17. {    
  18. alert "Invalid Postal Code";    cancel submit;
  19. }

But I'm now not sure where to now start to develop a function to achieve this.

Thanks in advance for your help.

Andrew