BusinessObjects Board

current date in Universe level object

building semantic layer
#1

Hi,

Please guide to me, how to create system date in universe level

please find below syntax and it’s not working

to_char(add_months(to_date(sysdate),0),‘YYYYMM’)

Backend : MS SQL

Please giv the syntax for above.

Thanks in advance.

With warm regards,

udayabsl (BOB member since 2010-03-16)

#2

That’s oracle syntax and your database is SQL. Try getdate()

Debbie

Debbie :uk: (BOB member since 2005-03-01)

#3

Have a look at this thread.

Regards,
Mark