>>>>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
>>>
>>>
>>>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
