time field conversion...Again!

[trustsun]

Hi gang, one of those infamous date conversion issue.

I have a time field like 2:44:15 AM. I need to convert this time field into a date field like 1/2/2006.

Here's what I've tried so far, CDate([CHGTIME]).

-trust

 

[SkipVought]

Hi,

Date/Time is contained in a single value. The DATE portion is the integral part and the TIME portion is the fractional part. What you see is merely a FORMAT to that combined value.

Just change the format of that field.

Skip,

_{[red]Be Advised![/red] The only distinction between a bird with one wing and a bird with two, is merely...
a difference of A Pinion!}