RFX_Date alternative
Posted
by Jarek Jaskolski
on August 6th, 1998
In the topic: "Database Programming"-'look subject of the message' there is the remark to do not use CTime (its true), but TIMESTAMP_STRUCT (not an object) in Access ODBC programming instead. In my programs I use COleDateTime (prima!), and just the following code must be supported to handle field exchange:
void RFX_DateTime( CFieldExchange* pFX,
const char* szName, COleDateTime& value )
{
CTime tm = CTime((value.GetYear()<1970 ? 1970 : value.GetYear()),value.GetMonth(),
value.GetDay(),value.GetHour(),
value.GetMinute(),value.GetSecond());
RFX_Date(pFX, szName, tm);
value.SetDateTime(tm.GetYear(),tm.GetMonth(),
tm.GetDay(),tm.GetHour(),
tm.GetMinute(),tm.GetSecond());
// instead of RFX_Date(pFX, szName, value);
}
Of course it does not exceeds date limitations of CTime bottleneck, but
user has COleDateTime object with all its' functionality for 'near
future' (till 2038).

Comments
how define time field in DAO and how write date of system on that field
Posted by Legacy on 03/02/2003 12:00amOriginally posted by: ASHKAN
Dear sir,
ReplyI create a *.mdb file with DAO but I can not write date of system in one field of database record. In other word I dont know how define time field in DAO and how write date of system on that field.Please help me with a source file
thanks in advance,
sincerely yours,