Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Need help please, converting a timestamp into a decimal for comparison reasons.
Is there a function that will convert a timestamp field (MM/DD/YYYY hh:mm) into a decimal?
In my script, this statement results in MinDate becoming a decimal:
MIN([Staff Start Date and Time]) As MinDate ... via a left join.
Now, I need to compare the [Staff Start Date and Time] to see if it equals the MinDate and need to first convert it to the same format as MinDate.
I found the answer.
Num([Staff Start Date and Time]) As OriginalDate
Will convert the timestamp field into a decimal.
Hi,
It convert it into number, as you say you want to see decimal place the date column.
Anand
Hi,
You need to round it to certain decimal places if you required it.
Regards
Anand