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:
01619269
Vues:
38
>>>>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
If it's not broken, fix it until it is.


My Blog
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform