Previous Date of Last Execution Date

system · April 18, 2005, 7:00pm

Hello,
I want to get a Previous day of LastExecutionDate() at the webi. How should be the formula? If I am giving the formula as
LastExecutionDate()-1
then its giving me syntax.
Can you please help me out?
Thanks…

rajkiransri (BOB member since 2005-04-07)

system · April 18, 2005, 7:12pm

LastExecutionDate() needs Dataprovider Name as a parameter.

=LastExecutionDate("Query 1 with efashion") -1

mkumar (BOB member since 2002-08-26)

system · April 18, 2005, 7:49pm

But its giving me error as follows:
the subexpression uses invalid datatype

rajkiransri (BOB member since 2005-04-07)

system · April 18, 2005, 7:53pm

I did not notice you wrote “in webi”.

Is it a Full Client report viewed in WebI or is it a WebI report?
Probably you will get better answer if you post it in WebI forum.

BTW Welcome to B B.

mkumar (BOB member since 2002-08-26)

system · April 18, 2005, 7:55pm

its in webi… sorry for that

rajkiransri (BOB member since 2005-04-07)

system · April 18, 2005, 8:06pm

Moved to the Webi 6 forum and deleted your other duplicate post in the Reporter forum.

Thank you.

Andreas (BOB member since 2002-06-20)

system · April 19, 2005, 9:32am

Try this
=RelativeDate(LastExecutionDate();-1)

Anil Kumar (BOB member since 2005-04-19)

system · April 19, 2005, 2:17pm

Thank you. Its working…

rajkiransri (BOB member since 2005-04-07)

system · February 9, 2016, 6:42pm

Thanks !!!

LEVYLC (BOB member since 2016-02-09)