View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.programming
RG III RG III is offline
external usenet poster
 
Posts: 65
Default Converting dates


It even works when the input date string has hyphens, such as:

"1-3-2019" ' This gets converted to "01/03/19"

"1-3" ' This also gets converted to "01/03/19"


I forgot to ask, how can I test if the input string does NOT resemble a date string (or even a date string with hyphens like above)?