>I am trying to run the following simple query
>date_sent is a datetime field and I am tryimg to extract the date
>portion from the datetime
>
>select date(year(date_sent),month(date_sent),day(date_sent)) as thedate;
>from cat_sent into cursor tempcurs
>
>When I do so I get the Function argument, value , type or count is invalid message
>
>However the date(year(date_sent),month(date_sent),day(date_sent)) syntax by itself seems to be valid when I use it ftom the command window
>
>Any help is appreciated in advance !
Bob,
Just use TTOD() function
select TTOD(date_sent) as thedate from cat_sent into cursor tempcurs
--sb--