NetTalk Central

Author Topic: Filter between dates  (Read 3432 times)

lkeyser

  • Jr. Member
  • **
  • Posts: 69
    • View Profile
    • Email
Filter between dates
« 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

Vinnie

  • Full Member
  • ***
  • Posts: 182
    • View Profile
    • Email
Re: Filter between dates
« Reply #1 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

lkeyser

  • Jr. Member
  • **
  • Posts: 69
    • View Profile
    • Email
Re: Filter between dates
« Reply #2 on: April 27, 2015, 05:13:20 AM »
Thanks Vinnie

 just had to change the second >= to <=

Regards
Louis