Message
From
02/02/2017 19:35:45
To
02/02/2017 19:33:25
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
01647380
Message ID:
01647390
Views:
34
>>>>Hi,
>>>>
>>>>Say I have a variable that contains a date. I want to add to it the current time and make the value DateTime type.
>>>>How do you do it? TIA
>>>
>>>
>>First, thank you. Something is not working for me. Let me clarify. I want the value of (your example, m.Yesterday) to be converted to the DateTime that has the current time. For example, I want the variable to have:
>>tYesterday = '2017-01-31 18:49:111'
>>
>>If you see my message to myself hopefully you will see what I mean.
>
>Hm... the important is that you have a solution that works for you, but, for the record, I think that what I suggested does what you was looking for, and it is not affected by VFP settings.
>
>
>>>>
>>>>Say I have a variable that contains a date. I want to add to it the current time and make the value DateTime type.
>>>>How do you do it? TIA
>>>
>>>
>>>m.Yesterday = DATE() - 1 >>>? VARTYPE(m.yesterday),m.yesterday >>>m.yesterday = DTOT(m.yesterday) + SECONDS() >>>? VARTYPE(m.yesterday),m.yesterday >>>>>
>>First, thank you. Something is not working for me. Let me clarify. I want the value of (your example, m.Yesterday) to be converted to the DateTime that has the current time. For example, I want the variable to have:
>>tYesterday = '2017-01-31 18:49:111'
>>
>>If you see my message to myself hopefully you will see what I mean.
>
>Hm... the important is that you have a solution that works for you, but, for the record, I think that what I suggested does what you was looking for, and it is not affected by VFP settings.
>
>
>LOCAL Yesterday > >m.Yesterday = DATE() - 1 > >SET DATE ANSI >? CTOT(DTOC(m.Yesterday) + ' ' + TIME()), DTOT(m.Yesterday) + SECONDS() > >SET DATE LONG >? CTOT(DTOC(m.Yesterday) + ' ' + TIME()), DTOT(m.Yesterday) + SECONDS() >Thank you very much.
"The creative process is nothing but a series of crises." Isaac Bashevis Singer
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham
"My experience is that as soon as people are old enough to know better, they don't know anything at all." Oscar Wilde
"If a nation values anything more than freedom, it will lose its freedom; and the irony of it is that if it is comfort or money that it values more, it will lose that too." W.Somerset Maugham