Skip to Content
Former Member
Aug 01, 2007 at 07:43 PM

Manipulating fields in a view


I have a table with a date and a time and I really need that data in a datetimestamp format. I'm trying to avoid creating a custom table and a custom program to get this information that already exists in this table.

If I put the data in a view, is there any way to perform calculations on the fields and show that as another field in the view?

I've got a view partially set up, but I just don't see a way to manipulate the fields to that degree?

Or any other way to do this without creating a custom table with the right field type and a program that converts the data from one to the other?

Thanks for any help.