Hi All
I have the following @DBlookup
@If(@IsNull(Startdate);“”;@DbLookup( “”:“NoCache” ; “” : “” ; “StockView / Remove Report” ;Startdate:enddate ; 3 ;[FailSilent]))
On the form I have two fields
StartDate and Enddate. what I would like is my @DBlookup to display all dates between and including themselves, but as you see from my lookup that it is only using a list so it only displays the actual value in Startdate and the actual value in enddate, can I get this to display all date values in this range?
If this is not possible, how can I create a field that takes the Startdate and endate and populates all dates withing the range then I can base my @DBlookup on this field.
Regards
Douglas Bell