problem in deleting mm/dd/yyyy

[zhed0708]

can anyone help me how to delete mm/dd/yyyy date format?and its type in the table is in DATE. when i run the form and delete the value of my txtdate, the character / is also deleted..how can i remain those two character signs (//)?
thanx for advance...

zhed

 

[Mike Lewis]

Zhed,

Once again, you're going to have to make your questions clearer. What exactly do you mean when you ask "how to delete mm/dd/yyyy date format?" How to delete it from where?

And what does "and its type in the table is in DATE" mean?

I hope you don't mind me pointing this out to you. But, you'll get a much better response if you would only take a moment to read over your questions, and check that they make sense to someone who doesn't know anything about your work, your environment or what you are trying to achieve.

Mike



__________________________________
Mike Lewis (Edinburgh, Scotland)

Visual FoxPro articles, tips, training, consultancy

 

[GriffMG]

You could put a format clause on the text box...
in the inputmask on the data tab enter 99/99/9999

Regards

Griff
Keep [Smile]ing

There are 10 kinds of people in the world, those who understand binary and those who don't.

 

[zhed0708]

sir mike...
how to delete mm/dd/yyyy date format in my date textbox....

zhed

 

[GriffMG]

If you want to clear the date format programmatically:

thisform.text1.value = ctod("")
thisform.text1.inputmask = ""



Regards

Griff
Keep [Smile]ing

There are 10 kinds of people in the world, those who understand binary and those who don't.

 

[zhed0708]

thanx sir GriffMG

zhed

 

[Olaf Doschke]

You wanted no formatting/mask in your textbox. Why did't you simply open the property windw, choose the ALL Properties Tab and browse through what is differing from default?

It's even more easy, if you right click on the uppermost combobox right under the properties window title bar and choose "Non-Default Properties Only". This way you'll see what properties are changed from their default and can simply reset them to their default.

And if all else fails, why not simply put a new textbox on the form, if you don't find out, which property is handling what feature.

Bye, Olaf.

 

[GriffMG]

Olaf

I think zhed is struggling to express himself very clearly.

He's just assigned a control to a databse field and doesn't quite understand the consequences... so you have to cut him a bit of slack.


Regards

Griff
Keep [Smile]ing

There are 10 kinds of people in the world, those who understand binary and those who don't.

 

[JRB-Bldr]

Griff - the problem is that zhed (zhed0708) has posted question after question (at least 5 just since Aug 11) in the same frustrating manner.
Now the number of questions isn't, by itself, really a problem - although it does suggest a SEVERE lack of understanding about VFP.

He's just assigned a control to a databse field and doesn't quite understand the consequences - might be just one example of that SEVERE lack of understanding.

Regardless, the biggest problem is that he is seeming to ask for line-by-line solutions to each of these challenges - not suggestions or advice which could assist or guide HIS really learning VFP and doing the needed work himself.

Plus, add to that, the fact that each challenge that he is asks about is most often not really stated or, at best, poorly described (the "frustrating" part) so that our ability to help him is often a very tedious and tiresome process.

OK, English might be a 2nd language for him and for that I'll cut him some slack, but he should get it by now that explaining things clearly will get to the answer MUCH easier.

If he is really looking for line-by-line solutions then he needs to hire someone to give that to him - not just keep coming back here time and time again - expecting us to write his application's code for him.

Otherwise he needs to spend some time like the rest of us have done to really learn VFP - from books, on-line video tutorials, and other sources.

After that he can come back with the few remaining questions about challenges.

Just my own frustrated two cents...
JRB-Bldr

 

[GriffMG]

Fair dos.

Regards

Griff
Keep [Smile]ing

There are 10 kinds of people in the world, those who understand binary and those who don't.