Hi,
I have a huge database where each column consists of millions of observations. one column is a column of dates but in text format (Dates1 column) and the second column is a column of dates but in a date/time format (Dates2 column).
First I tried to have them in the same format by changing the type in design view but I was always receiving an out of memory error. I would like to obtain instead of dates numbers in the two columns. Is their a way of doing so?
I have a huge database where each column consists of millions of observations. one column is a column of dates but in text format (Dates1 column) and the second column is a column of dates but in a date/time format (Dates2 column).
First I tried to have them in the same format by changing the type in design view but I was always receiving an out of memory error. I would like to obtain instead of dates numbers in the two columns. Is their a way of doing so?