Wrox Home  
Search P2P Archive for: Go

  Return to Index  

pro_vb thread: dates


Message #1 by "Ken" <ken.mcintosh@s...> on Mon, 12 Mar 2001 17:15:00
This is true
> I think if you do something like this:
> 
> If IsDate(dtMyDate) Then
> 	dtMyDate = CDate(dtMyDate)
> End If
> 
> dtMyDate will be formatted in a predictable manner.  

You will end up with the date formatted according the regional settings of 
the machine. The problem is whether the user inputs the date correctly. If 
you have remote users in different countries then they will input dates in 
different formats and it will be difficult to tell which format a given 
input was in (e.g. on the internet). In this case it is better to have the 
date entered in combo boxes in the form yyyy mm dd i.e. 3 combos.

Ian

  Return to Index