General information
Category:
Coding, syntax & commands
Title:
Looking up values in an array
I have a variable (called bd) that contains a date put in by a user. I also have an array that has list of dates retrieved from a table. I am looking for a date that the user entered against the array that fetched the dates from a table. The date that I am trying to retreive from array has to be either >= user inputted date. What is the fastest way to search for a date in an array that can be greater than or equal to value user input
&&user inputted date
bd=.t1.value
&& dates from table
SELECT DISTINCT (bdate) FROM payroll!payroll_tbl into array a__gen1
I tried the ascan but I don't think it supports >= expressions.
Thanks
Nick Patel
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only