Its better if you format it year month day, that way you'll never have a
leading 0. i.e. 20000101
Taz
----- Original Message -----
From: "Nagesh Kumar Deva" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Friday, June 02, 2000 6:19 AM
Subject: 1012000 to 01012000
> hi all,
>
> i strucked up with one silly problem. ie., i could not able to get the
> output like 01012000 as when i tried to insert individual dateofbirth to
his
> password.
>
> I am getting output from database as 01012000(dd/mm/yyyy) by dateformat
> function. But when go for updating the password with this date(now we can
> call it as a number) it is just taking 1012000 like this.
>
> Is there anyway to get same thing like 01012000. i got some idea to change
> password datatype to intezer or numeric but it wont work out for the
> passwords which r characters.
>
> plzz help me out
>
> thanx in advance.
>
> nagesh
> --------------------------------------------------------------------------
----
> Archives: http://www.eGroups.com/list/cf-talk
> To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or
send a message to [EMAIL PROTECTED] with 'unsubscribe' in
the body.
>
------------------------------------------------------------------------------
Archives: http://www.eGroups.com/list/cf-talk
To Unsubscribe visit
http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk or send a
message to [EMAIL PROTECTED] with 'unsubscribe' in the body.
