>Have a Date datatype in a grid - date1. On the database the field is a datetime - datetime1. If the client enters a new Date in the grid, want to stuff that date into the datetime field. The client can enter a past or current date.
>
>if ttod(datetime1) != date1
> datetime1 = datetime()
>** now want to make the date portion of datetime1 = date1
>endif
>
>thanks
>
>Brenda

m.tDt = DATETIME()
m.dDO = m.dSomeDate                 && or whatever date/date variable you need
m.nSecs = m.tDt-DTOT(TTOD(m.tDt))   && Get the seconds from the original DateTime value
m.tNew = DTOT(m.dDO) + m.nSecs      && Add the seconds to the Date value that's converted to a DateTime value
?m.tNew