Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

problem in deleting mm/dd/yyyy

Status
Not open for further replies.

zhed0708

IS-IT--Management
Jun 25, 2011
41
PH
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
 
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
 
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.
 
sir mike...
how to delete mm/dd/yyyy date format in my date textbox....

zhed
 
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.
 
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.
 
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.
 
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
 
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.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top