>>[The next update will occur at ]+subst(time(),1,3)+alltrim(str(val(subst(time(),4,2))+15))
>>
>>To get this:
>>
>>The next update will occur at 16:50
>That won't work because at 16:50, if you use the above command, the next update will occur at 16:05. I think the solution would be a bit more complex than that.
Absolutely correct. I was just showing how to do math using the time. I'm not sure exactly what the final outcome should be, he may only want a 12 hour clock, he may want am or pm. But the fact that there is a way to perform a math function on the time is the answer.
For one of my applications I actually use two or three lines of code using iif() for am or pm, and turning the 24 hour time into 12.
I thank you for pointing out the issue and possible this conversion will aid the original questioner to the correct path.
DJ :o)
Précédent
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement