How do I handle this date?

  • Thread starter Thread starter needin4mation
  • Start date Start date
N

needin4mation

Hi, I have a database that requires dates in this format:

30-sep-2006

The ODBC driver does not convert. In 1.1 I either parsed the date and
put it in the right format or used a validator on the client side
explaining how to submit the date.

I haven't written anything big in 2.0 and don't want to start
incorrectly. How would you handle the date here? Is it the same as
1.1? Is there some "new" way to do it? The regular user here would
enter the date normally as 09/30/2006. thank you for any advice.
 
I would save it in a Date variable and then use the ToString() method with a
format parameter to output it in whatever format you want. If necessary, you
can also specify the format the date is in when saving it to the Date
variable. For more information, see the documentation on creating and
formatting dates.
 
Hi, I have a database that requires dates in this format:

30-sep-2006

The ODBC driver does not convert. In 1.1 I either parsed the date and
put it in the right format or used a validator on the client side
explaining how to submit the date.

I haven't written anything big in 2.0 and don't want to start
incorrectly. How would you handle the date here? Is it the same as
1.1? Is there some "new" way to do it? The regular user here would
enter the date normally as 09/30/2006. thank you for any advice.
Click to expand...

Firstly, you should not allow your users to enter dates in a potentially
ambiguous way. E,g, you might see today's date as 10/02/2006 - to me, that
says 10th February... However, you are at least trying to convert the user
entry into an unambiguous format, so that's not quite so bad...

As for how you do this, there's really not much difference between v1.x and
v2...
 
Back
Top