Hey All,

I'm working on a little "countdown to a certain date" code (found here).
After searching this forum for the last couple of hours, I'm confused about
the regional settings.

I've read stuff about Bulgarian settings, this Format, that Format, you should
Format, you shouldn't Format. I just don't want people in other countries
to have any problems.

My questions are...

1. Does the Now function always return the Short Date format? (it does for
me)

2. Is there anything wrong with the code below? (works for me)

VB Code:
  1. 'Dim sEnd As String
  2. Dim sEnd As Date
  3.  
  4. Private Sub Timer1_Timer()
  5. 'Dim sStart As String
  6. Dim sStart As Date
  7. Dim sLabel As String
  8. Dim lDays&, lHours&, lMinute&, lSeconds&
  9.  
  10.     'sStart = Now
  11.     sStart = CDate(Now)
  12.     lSeconds = DateDiff("s", sStart, sEnd)
  13.    
  14.     lDays = lSeconds \ 3600 \ 24
  15.     lHours = lSeconds \ 3600 Mod 24
  16.     lMinute = ((lSeconds Mod 3600) \ 60)
  17.     lSeconds = ((lSeconds Mod 3600) Mod 60)
  18.    
  19.     sLabel = "Time left: " & _
  20.                 lDays & " days " & _
  21.                 lHours & " hours " & _
  22.                 lMinute & " minutes " & _
  23.                 lSeconds & " seconds"
  24.                
  25.     Label1.Caption = sLabel
  26. End Sub
  27.  
  28. Private Sub Form_Load()
  29.     'sEnd = Format(Date, "Short Date")
  30.     sEnd = CDate(Fix(Now))
  31.     sEnd = DateAdd("d", 2, sEnd)
  32.     Timer1.Enabled = True
  33. End Sub

Thanks in advance,
Ron