converting timestamp into decimal

[#1]

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.

[#2]

I found the answer.

Num([Staff Start Date and Time]) As OriginalDate

Will convert the timestamp field into a decimal.

[its_anandrjs]

Hi,

It convert it into number, as you say you want to see decimal place the date column.

Anand

[its_anandrjs]

Hi,

You need to round it to certain decimal places if you required it.

Regards

Anand