Formate( date, dd/mm/yyyy) use making my dates today's date

[Pradeepg]

Hi Experts,

I have a problem. When make use for format date it making my date as today's, how to retain the date which I had entered earlier.

Example:
Entered date as below: 13/11/2013
DOBBox.Value = Format$(Date, "DD/MM/YYYY")
Cells(LastRow, 19).Value = Month(DOBBox.Value)

saves the data as 18/12/2013, that today's date. Instead I need 13/11/2013 (which I had entered in my DOBbox text box.

Could anyone help in this regards?

Thanks in advance.

Pradeep

[xlbiznes]

You are using current date (Date) so its showing current date and not the entered date value

So change this

DOBBox.Value = Format$(Date, "DD/MM/YYYY")

to

DOBBox.Value = Format$(DOBBox.Value, "DD/MM/YYYY")

[Pradeepg]

Thanks a lot, it started to work for me.

[xlbiznes]

You are welcome.

Please mark this thread as solved , if you are satisfied with the solution.