Let me start by stating we are using BO WebI XIr1 on a Windows OS Server.
I am trying to remove the timestamp from a date field used in the LOVs. Has anyone been able to do this whil still maintaining the date format? We have been successful in removing the timestamp using:
SELECT DISTINCT
rtrim(convert(char, dbo.fctTesting.BusinessActivityDate,101))
FROM
dbo.fctTesting
ORDER BY
1 desc
This however will not sort by date but rather will sort the date as a char. The result is a sort based on the left characters so 1/1/2004 would be followed by 1/2/2005 then 1/3/2004 and so on. We have also tried VARCHAR and sorting on the BusinessActivityDate and none of these worked.
Has anyone been able to remove the time and still be able to maintain the date properties?
BO Dude 
(BOB member since 2004-04-02)
(BOB member since 2005-01-06)