Calculate First date and last date

[#1]

Hi guys,

I want to calculate first date and last date.

Calculation logic : 1.  First date -> From Date of Report = Day before Yesterday.

2. Last date ->  To Date of Report = Yesterday

How can I calculate the above ?

Please Help.

[Anonymous]

Hi

check this

Let  From Date of Report=Today()-2

Let To Date of Report  = Today()-1

[#3]

Thanks for your reply.

Please suggest me how to achieve the following:

1.  Day before Yesterday Bid Value.

2. Yesterday Bid Value.Day before Yesterday Bid Value

ISIN	Quote Name	Day before Yesterday Bid Value	Yesterday Bid Value	Price movement	Position analysis	Source

[Anonymous · Accepted solution]

Hi

I think can use set analysis for this  if  'Bidvalue' is a feidl like this ....

LOAD * INLINE

[

ISIN,Date,Bidvalue

ISN011, 07/22/2016,65.66

ISN012, 07/21/2016,45.5

ISN011, 07/21/2016, 64.42

ISN011, 07/20/2016, 63.45

ISN011, 07/19/2016, 60.52

ISN012, 07/19/2016, 45.45

]

Dimension : Date , ISIN

use following  Expression in the PIVOT TABLE

exper1:((Day before Yesterday Bid Value)

SUM({<Date={"$(=date(Today()-2,'MM/DD/YYYY'))"} >}    Bidvalue)

expr2:Yesterday Bid Value.

SUM({<Date={"$(=date(Today()-1,'MM/DD/YYYY'))"} >}    Bidvalue)

or

use like this ....

sum({<Date={">=$(=date(Today()-2,'MM/DD/YYYY'))<=$(=Date(Today()-1,'MM/DD/YYYY'))"} >}    Bidvalue)