Convert Month name and Year name to integer

[sbrunswik]

I am needing some assitance. I need to select the correct record from one table based on the date values of another table. I have two name fields {table.month} and {table.year} I need to select another record that has {anothertable.startdate,(dd,mm,yyyy)} and {anothertable.enddate,(dd,mm,yyyy)}. Any ideas on the best way to do this?

Thanks for any help

 

[herbsza]

Hallo sbrunswik,

If the fields {table.month}/{table.year} are a string value
then use the following in the record selection formula

(tonumber({table.year}) = year({anothertable.startdate,(dd,mm,yyyy)}) or
tonumber({table.year}) = year({anothertable.enddate,(dd,mm,yyyy)})) and
(tonumber({table.month}) = month({anothertable.startdate,(dd,mm,yyyy)}) or
tonumber({table.month}) = month({anothertable.enddate,(dd,mm,yyyy)}))

I have assumed that the {table.year} = '2004' and
{table.month} = '2'
I have writtern the record selection formula so that the startdate and enddate are in the same year and month. Modify to suit your needs.