Display of current date in report

building reports webintelligence
1

Hi,

I had to display in the report as ‘Data current as at 1st of May 2010’. I can display the date using the formula lastexecutiondate() but i want to be displayed in the format as 1st of May 2010 insteaad of date format
ddmmyyyy or yyyymmdd

Can any one please advice.

Thanks,
Eswar

Eswar (BOB member since 2006-05-02)

2

It depends what you want to do with your date. You can put the following around the lastexecutiondate()

=FormatDate(LastExecutionDate();"dd Mmmm yyyy")

This will give you a date that look 01 May 2010

If you want to put in the ‘st of’ or ‘nd of’ or ‘rd of’ or ‘th of’ then you will need to build some logic to do that as there are no functions or formats with BO that you can use for it.

plessiusa :netherlands: (BOB member since 2004-03-22)

3

Thanks a lot Arjan

Eswar (BOB member since 2006-05-02)