Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have one date field [Inventory Date] . I want to keep Start date always as 01/01/2011 and End date should be date with
Customer select in list box for Inventory Date..
date([Inventory Date],'DD/MM/YYYY') as [Inventory Posting Date]
vStart =Date(date#('01/01/2011','DD/MM/YYYY'),'DD/MM/YYYY') //// Minimum date for Posting Date is 01/01/2011.
VEnd = Max(date([Inventory Posting Date],'DD/MM/YYYY'))
Sum({< [Inventory Posting Date] = {'>=$(=Date(vStart))<=$(=Date(vEnd))'} >} [Item Ledger Entry Quantity])..
When User Select Date from List box it should sum quantity from 01/01/2011 till selected Date.
Kinldy Help me on this.. Thanks in Advanced.
What you have isn't working? If not, may try these changes:
Sum({<[Inventory Posting Date] = {">=$(=Date(vStart), 'DD/MM/YYYY')<=$(=Date(vEnd), 'DD/MM/YYYY')"}>} [Item Ledger Entry Quantity])
Hi Sunny,
Thanks for Ur Reply.. But when i m selecting a date from list box , its giving me sum([Item Ledger Entry Quantity])
for that Day only.. I dont understand why its not working...
Are you making selection in [Inventory Posting Date] or do you have another field you make selection in? If Date filter is another field, then you might have to tell your expression to ignore any selection made in date list box:
Sum({<[Inventory Posting Date] = {">=$(=Date(vStart), 'DD/MM/YYYY')<=$(=Date(vEnd),'DD/MM/YYYY')"}, DateField>} [Item Ledger Entry Quantity])
Hi Sunny,
I am Having a [Inventory Posting Date] only in a List Box..