In the process of converting VFP based database to SQL server.
One problem faced is that for all date fields on screens( forms), as the dates fields (in VFP database) are now replaced by datetime in SQL, the fields are showing the time portion as well.
Would like to know solution for following:-
1) How to ensure all fields display only date portion of field. We also have the problem when capturing date values to our report queries, since the dates contain time, if we range the values (what used to be eg sales from 1/1/2006 to 31/1/2006 then, now we have to somehow default everything to 1/1/2006:00:00:00 to 31/1/2006:24:00:00. Any shortcut to do this?
2) We use fields for data input, how to default the date fields instead of having null values displayed like 01/01/1900 of something like that.
Thanks in advance
Yau