MDR: Date Time

Timestamp to Date/Time Format

In Access, this is how to make the MDR serial number into a date time format.

In a query in a new field type time:
format([timestamp]/1440+1, "mm-dd-yy ttttt")

To reverse that, the query would need two statements: 
One field would need to be midconv:format([datetime],"#.########") 
The second field is timestamp:format(([midConv]-1)*1440,"#.") 

In SQL, the MDR query would look something like this: 
SELECT convert(smalldatetime,convert(float,[Timestamp])/1440-1) FROM mCallEnd 
In Crystal Reports, you can use DateTimeValue (({mCallEnd.Timestamp} / 1440) + 1).

In Access, to make the CTE serial number into a date time format: 
In a query in a new field type time:format([timestamp]/86400+1, "mm-dd-yy ttttt")

To reverse that, the query would need two statements: 
One field would need to be midconv:format([datetime],"#.########") 
The second field is timestamp:format(([midconv]-1)*86400,"#.")

In SQL, the CTE query would look something like this: 
SELECT convert(smalldatetime,convert(float,[Timestamp])/86400-1) FROM EndCall 
In Crystal Reports, you can use DateTimeValue ({Command.Timestamp} / 86400) + 1.

Converting General Time Field Values: 
To convert the milliseconds in an export file or database file to minutes/tenths of minutes, divide by 60000.