Thread: VBA Date Format
View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Kieranz Kieranz is offline
external usenet poster
 
Posts: 12
Default VBA Date Format

Hi All
I tried the following and it seems to work
If FormatDateTime(dBD,2) < FormatDateTime(dRBD,2) then - ( 2 is
vbshortdate)
Thks and Rgds KZ