Calculations right after the query

[mindfields]

Hi all,

Please excuse my english but I'll make every effort so as to be as clear as possible.

Some of the objects provided to BO users are not in a convenient format right after the query, for instance all dates are stored in a numeric format (the number of days since Jan, Ist, 1900). Is their any means for the designer to turn raw data into more useful format right after the query, using VBA or calling API...?

I know this is confused but I hope I'll get some help though.

 

[bensonpa]

It depends on your database but the syntax for your object should be defined as something like:

Oracle -
to_date('01/01/1900','dd/mm/yyyy') + numberofdaysfield

SQL Server -
dateadd(d, numberofdaysfield, '01/01/1900')

No need to use VBA etc unless you're connecting to some sort of ropy database with no SQL functions.