Yesterday

[#1]

How to get the yesterday value from date field

eg:

Datefield

yesterday-11/27/2012

count(orders) for yesterday(11/27) is some x amount how to get this?

[#2]

Hi..

Today()-1=yesterday

if(datefield=Today()-1,Count(Orderes))

Hope it helps u

Regards,

Kabilan K.

[jagan]

Hi,

You will get Yesterday date by subtracting 1 from todays date. 

yesterdayDate = Today() -1

Internally the date is stored as number.

In expression you can use like this

=Sum({<DateDimension={'=$(=Today()-1)'}>} Sales)

Hope this helps you.

Regards,

Jagan.

[Anonymous]

Hi

you can use

LET Vyesterday = today()-1;

expression :

=count({$<Day={$(=max(Day($(Vyesterday))))}>} orders)

Hope this helps you.

Regards,

Akbar

[#5]

i tried the above conditions its not working it shows null

order date is the date field

need to calculate the yesterday count(order) for order date.

[sivarajs]

count({$<orderdate={"=$(=date(orderdate)-1)"}>}order)

[jagan]

Hi,

Did you tried this

=Sum({<DateDimension={'=$(=Today()-1)'}>} Sales)

If it not works then check where there is any Date format mismatch.

Regards,

Jagan.