Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Creating datetime from character fields
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Autre
Versions des environnements
Visual FoxPro:
VFP 9 SP2
OS:
Windows Server 2012
Network:
Windows 2008 Server
Database:
MS SQL Server
Application:
Web
Divers
Thread ID:
01619255
Message ID:
01619270
Vues:
31
>>>>>Works fine for me. Did you test it yoursef?
>>>>>
>>>>>set date BRITISH
>>>>>
>>>>>dater = "30/04/2015"
>>>>>
>>>>>timer = "09:57"
>>>>>
>>>>>? CTOT(dater + " " + timer)
>>>>>
>>>>>
>>>>>>set date to british
>>>>>>
>>>>>>dater is 30/04/2015
>>>>>>
>>>>>>timer holds 09:57
>>>>
>>>>It start to work at 10:00 - how do I get round this?
>>>
>>>Hah?
>>
>>when timer is 00:00 to 09:59 it doesn't create the datatime field
>
>I've tested all the values in a loop and everything was OK. Can you show your code and also identify the failing entries?
>
>
>set date BRITISH
>clear
>dater = "30/04/2015"
>
>FOR k=0 TO 10
>FOR i=0 TO 59
>	timer =  PADL(k,2,"0") + ":" + PADL(i,2, '0')
>	? CTOT(dater + " " + timer)
>endfor	
>endfor
replace fstat WITH CTOT(dater+" "+timer) where fstat is a date time field
Specialist in Advertising, Marketing, especially Direct Marketing

I run courses in Business Management and Marketing
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform