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,

Expression seems OK.

make sure you have proper date format.

Data(today()-1) will return you your system format date which is set in your script background.

Regards

ASHFAQ

[#3]

  [d Gregorian Full Date] is also set as date format in sql. i don't know what the problem is with my conditional part of the code.

[ashfaq_haseeb]

Your Code is fine

Make sure you drop date list box to front end.

and in new text box write =date(today()).

Check what are the date format are they similar.

If possible post a sample data.

Regards

ASHFAQ

[#5]

as you see there is no problem with the format because they can be added to each other. there should be some problem with the syntax of condition: [d Gregorian Full Date]={"$(=Date(today()-1))"}

[#6]

Your script code is correct,may be both date field means your system date field format for today is different from the

[d Gregorian Full Date] date field format. Try to change the date format which is different.

for eg: lets suppose date format of [d Gregorian Full Date] is DD-MM-YYYY and date format of Today() is DD/MM/YYYY

then you should use following code

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

hope this will help you.

if you still have any issue then post your sample app.

Regards

Bhawna

[#7]

You should use following code

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

[ashfaq_haseeb]

Hi,

As I say there is format issue.

Try below

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

Regards

ASHFAQ

[#9]

it doesn't work yet

[#10]

it doesn't work yet