Foxfire! Support Notes

Converting DateTime to Date Fields

Many databases do not support a separate Date format from DateTime. SQL Server is one of them - you can't have just a "date" field persay; it ends up being a date/time field.

But when you're putting these fields onto a report, you don't want to show the hour and minutes - you just want to see the date.

With Foxfire!, you can do this by using the TTOD() function in the Layout Expression field. The Report Expression on the main page is passed directly to the SQL Server but the Layout expression field is used on the output.

We've done up a screencast that shows how to do this, using the SQL Server Pubs database.

Check it out here!

posted by Andrew MacNeill @ 9/29/2006 12:19:00 PM