Assuming that the date occurred in the past...
If that number is supposed to represent '2005-06-06', then the conversion formula is ...
If it's supposed to represent '2015-06-06', then the conversion formula is ...
Both 1970 and 1980 we're the start dates of commonly used epochs.
If neither conversion works for you then, like Michael John stated, we need an example of what a given number would convert to.
is pronounced "ree-bar
" and is a "Modenism
" for R
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a row... think, instead, of what you want to do to a column.
"If you think its expensive to hire a professional to do the job, wait until you hire an amateur."--Red Adair
"Change is inevitable... change for the better is not."
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally)