previous event, next event
B

But Events appears in the left column (even if not visibile in the screenshoot) and Band is the table in which I'm writing the formula

Ninox Profile

Try this .. do NOT prefix 'Date termine' with the table name... It is implied that you are refering to the database column.  So rather than 

Events.'Date termine' ... just use 'Date termine' 

tryThis

As for the Band error... Same as above.. strike the Events. prefix...  Second.. please show me where "Band" exists on the left column..   Notice the it looks like it is interpreting the line a "B" and .. based on color coding.  I looked in mine.. it does the same.... 

B

@Mconneen 

"Try this .. do NOT prefix 'Date termine' with the table name... It is implied that you are refering to the database column.  So rather than 

Events.'Date termine' ... just use 'Date termine' "

Try it, simply empty answer :-(

 

"please show me where "Band" exists on the left column."

"Band" doens't appear in the left column becouse is the table into which I'm writing the code

 

 

Ninox Profile

@Birillio... I have got you close.. but am flying a bit blind here.. Might be time to scheudle a support call.. They are FREE.. and worth while.. 

https://ninoxdb.de/en/support

Scroll down.. and click Schedule a Meeting. 

 

B

ok, and thank  you a lot for your suggests :-)

1 2
Reply