Query survery variables but not using Existing Values

[Former Member]

Dear

i am going to make a qurey for aging report, i would like to use Query survery variables but not using Existing value, user wants to input Aging date freely like standard report.

however it will return NULL if user input a date value that does not contain in the table

Thanks

Gordon

Edited by: Gordon Ho on Jun 26, 2008 10:46 AM

[former_member204969]

You donu2019t need to use the existing values button, you can simple enter the desired value.

[Former Member]

Sorry , in the Business One , is there another method to pop up the query variable windows without something like this? if NOT , there are no way to let user input the desire value , it will return NULL if there are no document in that date

select @mthdate = ta.refdate from [dbo].[jdt1] ta where ta.refdate = '[%0]'

Thanks

Gordon

[Former Member]

there is no other option in B1 other that Survey Variables to promt input from Users.

[former_member204969]

Try something like this to get a manually entered date:

declare @mthdate datetime
/*select  ta.refdate from dbo.jdt1 ta where ta.refdate = '[%0]*/
set @mthdate='[%0]'

[Former Member]

thanks !! it work