Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Tai Nguyen
  Where is Tai Nguyen?
 
 United States
 Tai Nguyen
 To: Jun Tangunan
  Where is Jun Tangunan?
 Cabanatuan
 Philippines
 Jun Tangunan
 Tags
Subject: RE: Convert to "YYYY-MM-DD" and "hh:mm" text
Thread ID: 288055 Message ID: 289135 # Views: 21 # Ratings: 0
Version: Visual FoxPro 9 Category: General VFP Topics
Date: Tuesday, December 28, 2010 4:05:22 PM         
   


> >
> > ----------------------------------------------------------------------------
> > ----------------------------------------------------------------------------
> >
> > Jun,
> >
> > Your solution was great. Apparently I missed that "Set Mark To '-'". Now, one thing I need you to do is to fix your 'select' statement to make that 'xdate' as a string instead (to be compliant) before I can rate your input as helpful and for the future reference when they search through the Internet engines. Thanks.
> >
> > Tai Nguyen.
>
>
> Glad you liked it. :-)
>
> If you need xdate to be a string, then just remove the CTOD() function, so:
>
Select Dtoc(dtime) As xdate, Left(Ttoc(dtime,2),5) As xtime From junk

>
> Merry Christmas Tai!
>
>
> http://www.junblogs.com/
> http://weblogs.foxite.com/sandstorm36/default.aspx
> http://www.coderisland.com/forum/viewforum.php?f=10

----------------------------------------------------------------------------------
----------------------------------------------------------------------------------

Thanks sir. Sorry, I was out for 4 days.

Thank you very much and Merry Christmas to you too.

Tai Nguyen.

ENTIRE THREAD

Convert to "YYYY-MM-DD" and "hh:mm" text Posted by Tai Nguyen @ 12/16/2010 11:44:18 PM
RE: Convert to "YYYY-MM-DD" and "hh:mm" text Posted by anand kulkarni @ 12/16/2010 11:49:36 PM
RE: Convert to "YYYY-MM-DD" and "hh:mm" text Posted by Tai Nguyen @ 12/16/2010 11:55:31 PM
RE: Convert to "YYYY-MM-DD" and "hh:mm" text Posted by Anders Altberg @ 12/17/2010 12:06:07 AM
RE: Convert to "YYYY-MM-DD" and "hh:mm" text Posted by Tai Nguyen @ 12/17/2010 3:50:01 PM
RE: Convert to "YYYY-MM-DD" and "hh:mm" text Posted by Mike Potjer @ 12/20/2010 9:07:58 PM
RE: Convert to "YYYY-MM-DD" and "hh:mm" text Posted by Tai Nguyen @ 12/23/2010 6:58:10 PM
RE: Convert to "YYYY-MM-DD" and "hh:mm" text Posted by Jun Tangunan @ 12/21/2010 2:48:51 AM
RE: Convert to "YYYY-MM-DD" and "hh:mm" text Posted by Tai Nguyen @ 12/23/2010 6:48:27 PM
RE: Convert to "YYYY-MM-DD" and "hh:mm" text Posted by Jun Tangunan @ 12/23/2010 11:21:19 PM
RE: Convert to "YYYY-MM-DD" and "hh:mm" text Posted by Tai Nguyen @ 12/28/2010 4:05:22 PM
RE: Convert to "YYYY-MM-DD" and "hh:mm" text Posted by Tai Nguyen @ 12/21/2010 8:15:24 PM