VFP7
I have a field of type DATE in a given table.
It would be nice to not only have the date but also the time of a given transaction.
If I change the type from DATE to DATETIME I'll have to change lines of code in several placed to take that change into consideration.
Now here's the thing. I just thought that perhaps a new field of type C(4) could be added instead of changing the DATE to a DATETIME. The name of that new field could be HourMinute.
For example if the time of transaction is 3.51 pm the characters stored would be "1551".
Does that make sense or is it really worth it to change to a DATETIME and do all the necessary fixes?
*******************************************************
Save a tree, eat a beaver.
Denis Chassé