About Frank_Gonzalez

Frank_Gonzalez · 03-23-2021

Based on a date, I must search a table for a value from another column, but the date is not necessarily exact, it can be within a range or be greater than the last one in the table. For example VUT - Table |Since |Value| | 19/02/2014 | 127 | | 25/02/...

Frank_Gonzalez · 03-26-2021

Have to change MIX to MAX on the SELECT … the list for this SELECT takes the rows where Dates ar greater and equal to Since … but the closest Since is the MAX

Frank_Gonzalez · 03-24-2021

Something likes … i will try with your code … thanks a lot

Frank_Gonzalez · 03-24-2021

Thanks. I’ve to search in the table with a date variable. the date must be greater than any … but it must not be greater than the next … if it exists If I look for the date 30/06/2016 the result should be 177 If I search 30/3/2017 the result should b...

My Stats

Frank_Gonzalez's Bio

Badges Frank_Gonzalez Earned

Recent Activity

Find a value in a table based on a date

Re: Find a value in a table based on a date

Re: Find a value in a table based on a date

Re: Find a value in a table based on a date