Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Michael Gill
  Where is Michael Gill?
 Flora
 Illinois - United States
 Michael Gill
 To: Suvi Joseph
  Where is Suvi Joseph?
 Bangalore
 India
 Suvi Joseph
 Tags
Subject: RE: How to extract only Date from DateTime field?
Thread ID: 15731 Message ID: 15749 # Views: 5 # Ratings: 0
Version: Unknown Category: General VFP Topics
Date: Sunday, September 29, 2002 3:37:34 AM         
   


> Dear All,
> I have a cursor which is having a field 'date1' which is of DateTime type. I want to show only the date portion of date1 in a text box(not the time). I tried giving the textbox Format property to 'DE' and 'YS' But It doesnt work. Is there anyway to extract only the date portion of the date1? Please help me on this.
>
> Regards,
> Suvi Joseph

There's a thread in here somewhere where I was wanting to just show the time portion. Paul Culbertson gave me an answer of how to do that. Look for that thread. Search for mine or pauls name with the datetime keyword.

---

www.foxite.com - The Home of the Visual FoxPro Experts

ENTIRE THREAD

How to extract only Date from DateTime field? Posted by Suvi Joseph @ 9/28/2002 10:14:40 AM
Poor me!! Posted by Suvi Joseph @ 9/28/2002 12:57:59 PM
RE: Poor me!! Posted by Raymond Hartman @ 9/28/2002 2:59:10 PM
RE: How to extract only Date from DateTime field? Posted by Karben Selim Mejia @ 9/28/2002 4:24:09 PM
RE: How to extract only Date from DateTime field? Posted by Michael Gill @ 9/29/2002 3:37:34 AM
RE: How to extract only Date from DateTime field? Posted by Suvi Joseph @ 9/29/2002 7:34:42 AM