hi!
I want to convert a date data collected from a user in dd.mm.yy format to yyyymmdd format and svae it in a database.

How can I convert date from dd.mm.yy format to yyyymmdd format?
any suggestion will be appreciated.

thank you in advance

hi there.. the format function is not enough for you??

datetime.tostring("yyymmdd")??

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

hi !
Thank you for your reply! I have tried what you have suggested me but it did not work. it gives me wrong number for the month "mm".

I have tested the following code . The code displays wrong output.


<script runat="server">

    Sub Page_Load()
            
             Response.write(DateTime.Now.ToString())
             Response.write("**************")
            
             Response.write(DateTime.Now.ToString("yyyymmdd") )
             Response.write("=========")
            
             Dim dt as Date=Format(Now(),"dd/MM/yyyy")
             response.write(dt)
    end sub

</script>

output:

29.10.07 08:54:25********20075429=========29.10.07 00:00:00

I am getting wrong number - 54 for mm, which is not true


can someone help me.

yep.. you are rigth.. you have to use MM... mm is for minutes...just use yyyyMMdd

HTH

Gonzalo

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
^^Took that from dparsons signature and he Took that from planoie's profile
================================================== =========
My programs achieved a new certification (can you say the same?):
WORKS ON MY MACHINE
http://www.codinghorror.com/blog/archives/000818.html
================================================== =========
I know that CVS was evil, and now i got the proof:
http://worsethanfailure.com/Articles...-Hate-You.aspx
================================================== =========

belete -

Why are you storing a date value as a string instead of a datetime? If you store it as a datetime time it will be MUCH easier to format it later without having to always convert it from a string into a real date value. It's probably also more efficient because it will store the value as a numeric value instead of just a string of characters.

-Peter

Thank you guys it is now working!

Planoie:
It is better to save it as datetime as you have said. I will later reterive it back by using GridView from the database. It will be much easier.

belete