How do you get yesterday date with format-dateTime function

[Mark Leung]

Dear BW expert,

We would like to get yesterday date from current date. How to write xpath expression with format-dateTime function to get the yesterday date

Please advise!

Thanks!

[Francisco Crespo 4]

Hi,

To find yesterdays dateTime use the expression:

tib:add-to-dateTime(current-dateTime(), 0, 0, -1, 0, 0, 0)

and use that as the dateTime value in format Datetime.

In short, your expression should look similar to:

tib:format-dateTime('MMM dd YYYY - HH:mm:ss', tib:add-to-dateTime(current-dateTime(), 0, 0, -1, 0, 0, 0))

 

If you are only interested in the date part, use

tib:format-date('MMM dd YYYY', tib:add-to-date(current-date(), 0, 0, -1))

Regards,

Francisco