Sage 100

We are upgrading a client from providex to SQL and they have some Business Insights views set up with a calculation that subtracts one date from another.  This isn't working properly in SQL and I think it's because SQL stores dates as date and time.  I haven't been able to find a way to convert the Date/Time to Date only in BIE with the SQL back end.  I'm hoping someone has figured this out already and would appreciate any suggestions.

Thanks!

------------------------------
Bernie Lehman
Partner
Lehman Wesley & Associates
------------------------------

Have you tried using a calculated column added to the view that uses T-SQL's CONVERT function?

Have you tried using column level formatting?

Have you tried using the DateAdd function in the calculation?

------------------------------
David Speck II
Blytheco, LLC
------------------------------