Skip to main content
A
Anonymous
March 13, 2009
Question

my query returns 0 records

  • March 13, 2009
  • 1 reply
  • 375 views
attached is the query I constructed to retrieve the expired permits. I
This topic has been closed for replies.

1 reply

K
Kronin555
Participating Frequently
March 13, 2009
I'm guessing you're gonna need to change this:
AND zef_date_permit_exp = #from_date#
to this:
AND zef_date_permit_exp > '#from_date#'

What exactly is stored in from_date? you might need to do some formatting as well...
Terms & ConditionsAccessibility statement
Using the community Terms of use Privacy Cookie preferences Do not sell or share my personal information ad choicesAdChoices