Hi,

I got a problem with the date format for that I need work around.

I have a date in dd-mm-yyyy hh:mm:ss format. I simply want to convert into mm/dd/yyyy hh:mm format.

I used format function. but it is not coverting the date properly. For example,
VB Code:
  1. Debug.print Format("02-05-2006 20:53:56", "mm/dd/yyyy HH:mm")

  2.  
  3. 02/05/2006 20:53 'This should be 05/02/2006 20:53 

  4.  
  5. Debug.print Format("18-05-2006 20:53:56", "mm/dd/yyyy HH:mm")

  6.  
  7. 05/18/2006 20:53 'This is correct. no issues.

Somebody help me on this please.

Thanks,

CS.