Origination of CurrentDate

building reports desktopintelligence
1

Hi Everyone!! We are currently preparing to do testing for Y2K. We are setting up our test environment and the following issue came up. The question is, where does the CurrentDate function get the date from. Is that date ‘sysdate’ from the Oracle database or is it from the PC maybe.

From Designer, we can pull ‘sysdate’ so I feel like that is the Oracle
field but we wanted to verify where the User Module date field came from. It won’t do much good to test the wrong functionality!!

BO - 4.1, Oracle 7.3, SQL*Net 2.3

Thanks for any input!!!

Maria D. Carter :slight_smile:
BusinessObjects Developer
(336) 279-2242
mcarter@gbncmail.ims.att.com

Listserv Archives (BOB member since 2002-06-25)

2

Depends upon whether you are referring to a User Object function or a Variable/Formula function. The User Object function is SYSDATE. The Variable/Formula function must be the PC’s date because it doesn’t query the database to get it.

Erich Hurst
Compaq Computer Corporation
(281) 514-9445
Erich.Hurst@Compaq.com

The question is, where does the CurrentDate function get the date from. Is
that date ‘sysdate’ from the Oracle database or is it from the PC maybe.

BO - 4.1, Oracle 7.3, SQL*Net 2.3

Listserv Archives (BOB member since 2002-06-25)