Solved

date/time expression in FoxPro 8

Posted on 2010-08-13
4
693 Views
Last Modified: 2012-08-13
What is correct format for date/time expression in FoxPro 8
0
Comment
Question by:shamel9873
  • 3
4 Comments
 
LVL 3

Expert Comment

by:AndrewJen
ID: 33431732
Can you be more specific?

Examples of the datetime() function:

tNewyear = DATETIME(YEAR(DATE( ) ) + 1, 1, 1)  && Next New Year
tToday = DATETIME( )
nSecondstonewyear = tNewyear - tToday
CLEAR
? "There are " + ALLTRIM (STR(nSecondstonewyear)) ;
   + " seconds to the next New Year."

CLEAR
SET CENTURY ON
SET DATE TO AMERICAN
? DATETIME(1998, 02, 16, 12, 34, 56) && Displays 02/16/1998 12:34:56 PM
0
 
LVL 33

Accepted Solution

by:
CarlWarner earned 500 total points
ID: 33432552
{^2010/08/15}
0
 
LVL 33

Expert Comment

by:CarlWarner
ID: 33434264
Thanks.

See the Date data type at the following link (that I always have trouble finding):

Visual FoxPro Data and Field Types
http://msdn.microsoft.com/en-us/library/ww305zh2(VS.80).aspx
0
 
LVL 33

Expert Comment

by:CarlWarner
ID: 33434294
And the explanation of the caret (^) is here:

StrictDateEntry Property
http://msdn.microsoft.com/en-US/library/txatcebx(v=VS.80).aspx
0

Featured Post

DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Title # Comments Views Activity
Insert into Excel a sum for three columns 8 623
Visual FoxPro Ver 9. What is UDDATA.PRG? 30 866
Copying a DBF file fails 9 261
Fox pro conversion 3 48
Microsoft Visual FoxPro (short VFP) is a programming language with it’s own IDE and database, ranking somewhat between Access and VB.NET + SQL Server (Express). Product Description: http://msdn.microsoft.com/en-us/vfoxpro/default.aspx (http://msd…
We need a new way to communicate time sensitive or critical info.   The best part of my role at xMatters is visiting our clients all over the world to learn about how they operate their businesses, share insights that xMatters has gleaned across…
This is used to tweak the memory usage for your computer, it is used for servers more so than workstations but just be careful editing registry settings as it may cause irreversible results. I hold no responsibility for anything you do to the regist…
With the power of JIRA, there's an unlimited number of ways you can customize it, use it and benefit from it. With that in mind, there's bound to be things that I wasn't able to cover in this course. With this summary we'll look at some places to go…

895 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now