NetTalk Central

NetTalk Web Server => Web Server - Ask For Help => Topic started by: lkeyser on April 27, 2015, 04:19:14 AM

Title: Filter between dates
Post by: lkeyser on April 27, 2015, 04:19:14 AM

I need some help please.
I have a browse with two filters: a "start date" and "end date"
Don't seem to get the syntax correct.

'COB:Date_Purchased >= p_web.GSV('Sales_start_date') and COB:Date_Purchased >= p_web.GSV('Sales_end_date')'

Can someone please help me.

Regards

Title: Re: Filter between dates
Post by: Vinnie on April 27, 2015, 05:01:26 AM

Your Filter:

'COB:Date_Purchased >= p_web.GSV('Sales_start_date') and COB:Date_Purchased >= p_web.GSV('Sales_end_date')'

I would make:

'COB:Date_Purchased >=' &  p_web.GSV('Sales_start_date') & ' and COB:Date_Purchased >=' &  p_web.GSV('Sales_end_date')

Hope this helps

Cheers

Vinnie

Title: Re: Filter between dates
Post by: lkeyser on April 27, 2015, 05:13:20 AM

Thanks Vinnie

 just had to change the second >= to <=

Regards
Louis