Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 704
  • Last Modified:

date/time expression in FoxPro 8

What is correct format for date/time expression in FoxPro 8
0
shamel9873
Asked:
shamel9873
  • 3
1 Solution
 
AndrewJenCommented:
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
 
CarlWarnerCommented:
{^2010/08/15}
0
 
CarlWarnerCommented:
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
 
CarlWarnerCommented:
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

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now