yesterday sale

[#1]

hi

i need yesterday's sales quantity so i wrote the code below, but it doesn't give true answer. any one knows what problem is with my code?

Sum ({ < [d Gregorian Full Date]={"$(=Date(today()-1))"}>} [F Sr Sales Quantity])

[ashfaq_haseeb]

Hi,

Can you attach sample file.

Regards

ASHFAQ

[#3 · Accepted solution]

hi

at end i found the problem. its the correct syntax:

Sum ({ < [d Gregorian Full Date]={"$(=Date((today()-1) ,'YYYY-MM-DD'))"}>} [F Sr Sales Quantity])

tnx a lot for your help about date format.

regards

Mana