Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DTOS and CENTURY Question
Message
From
20/08/2008 15:01:45
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
DTOS and CENTURY Question
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01340482
Message ID:
01340482
Views:
57
These two CASE conditions return "20051013" as the NewFieldValue, regardless of the CENTURY setting. It is a function in a SQL statement column, if that matters.

The value of FieldValue is:
{^2005/10/13}

					CASE EligCrit.FormatVal = 'YYYYMMDD'
						SET CENTURY ON
						NewFieldValue = STRTRAN( DTOS( FieldValue ), '/', '' )

					CASE EligCrit.FormatVal = 'YYMMDD'
						SET CENTURY OFF
						NewFieldValue = STRTRAN( DTOS( FieldValue ), '/', '' )
Next
Reply
Map
View

Click here to load this message in the networking platform