check date

[tulika agrawal]

hi all

i m using vb6.0

i asked the date information from user in dd/mm/yyyy format.

how can i check that the date entered by user is in correct date format.

please provide me some help.

in vb isdate() function is used to check the date in "mm/dd/yyyy" format. but i want to check in dd/mm/yyyy format

 

[BabuLives]

hai tulika..
Click this link..

http://searchvb.techtarget.com/vsnetTip/1,293823,sid8_gci960388_tax293037,00.html

Regards,
Satheesh

[BabuLives]

[tulika agrawal]

thanks

but i need in visual basic 6.0

in vb we can't use  regular expression.

please provide me in visual basic

 

[Aqil Shah]

Hi Tulika,

     use Format function for it.

if u r taking dtpicker then

 

    Format(dtpicker1.value, "dd/MM/yyyy")

 

 

'to check

 

if dtpicker1.value <> format(dtpicker1.value, "dd/MM/yyyy") then

         'code

end if

 

or if u r entering from text box then replace dtpicker.value by text1.text etc.

   Bye

   Aqil Shah

 

[tulika agrawal]

hi

thanks

but i m not using the date picker control.

i retrive the value from textbox.

 

[BabuLives]

Set the date format in control panel,under regional setting..

[tulika agrawal]

i can't use this . because other software were effectect by changing the regional setting, is there any othe solution to check date?

 

On 10/3/05, BabuLives <sathees...@gmail.com> wrote:

[Aqil Shah]

just replace the dtpicker1.value with text1.text.

 

 

On 10/3/05, BabuLives <sathees...@gmail.com> wrote:

[Aqil Shah]

why dont you use format function??

 

 

 

if nameoftextbox.text <> Format(nameoftextbox.text,"dd/MM/yyyy") then

    ' Doesnt match

else

    'proceed

end if

 

 

it is very simple.

 

 

[tulika agrawal]

thanks for all reply

but my problem is stlli remain same

 

On 10/3/05, Aqil Shah <aqil...@gmail.com> wrote:

[Aqil Shah]

mail your code, where is the actual problem ??

[BabuLives]

hai...
use Format function as said by aquil...

or else try this link it may help u out...

http://www.visualbasicforum.com/showthread.php?t=12364

http://www.officecomputertraining.com/vbtutorial/tutpages/page32.asp

Regards,
Satheesh

[tulika agrawal]

hi

read the following code
Text2.Text = Format(Text1.Text, "mm/dd/yyyy")
if user enter "4454545" in textbox1 than it gives the error overflow error

how can i remove this error.

 

On 10/3/05, BabuLives <sathees...@gmail.com> wrote:

[Aqil Shah]

if  isdate(text1.text) then

         Text2.Text = Format(Text1.Text, "mm/dd/yyyy")

else

     msgbox "Please enter valid date!", vbokonly

end if
 

[tulika agrawal]

great, it is working fine, same the way i m needed

earlier,i worked with isdate() function, i thought that it checks the date in only in "mm/dd/yyyy" format.

but i m surprised to see that its also chech the date in "dd/mm/yyyy" also.

thanks to u.

tulika

 

On 10/3/05, Aqil Shah <aqil...@gmail.com> wrote: