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 gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Date calculation
If today is 24 feb 2006: {^2006-02-24} is a literal expression for today, it is a date type expression same as what DATE() returns. In order to get {^YYYY-MM-DD} from a string variable (created in your case) I choose to use Transform() and Evaluate(). With Transform(created, "@R...- suchat
- Post #15
- Forum: Microsoft: FoxPro
-
Date calculation
Assuming that created is a character field. There are several way to convert a "YYYYMMDDHHMMSS" string into a date type variable. Evaluate() and Transform() with R format code is easy to read and the conversion is not affected by current date format setting. Date() -...- suchat
- Post #13
- Forum: Microsoft: FoxPro
