Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Transfer character TO Date Format
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP2
Miscellaneous
Thread ID:
01391975
Message ID:
01391978
Views:
82
>Hi all,
>
>I want to transform a caractere expression to a date Format.
>Please see attachment because i have a strange result.
>
>
> m.dte_Sortie =  CTOD( TempCrystal.ddepart )
>
>
>TempCrystal.ddepart is not empty and m.dte_Sortie give a empty string !?
>thank in advance For help
>
>bernhart

Hi Bernhart
Convert first TO Datetime and then use TTOD()
TTOD(CTOT(TempCrystal.ddepart ))
or
CTOD(LEFT(TempCrystal.ddepart ,AT([ ],TempCrystal.ddepart )-1))
TempCrystal.ddepart has DateTime value
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst
Previous
Reply
Map
View

Click here to load this message in the networking platform