0

variables in views formulas...

Hello everybody, another weird behavior...

why does this view formula work

let moi := this.ID;

(select Interactions where date(start('Rendez-vous')) = today() and Praticien = moi and (Type = 1 or Type = 2));

and not this one :

let ladate := today(); // or let ladate := fieldDate
let moi := this.ID;
(select Interactions where date(start('Rendez-vous')) = ladate and Praticien = moi and (Type = 1 or Type = 2));

thanks for help,

Marc

1 reply

null
    • Ninox Software
    • David_G
    • 5 yrs ago
    • Reported - view

    let ladate : = is called on the client, and it fills the variable with a timestamp type. Whereas inside the select, it is called on the server. If the server and client are on different timezones, this will fail. 

     

    -David

Login to reply

Content aside

Categories

View all topics
  • 5 yrs agoLast active
  • 1Replies
  • 845Views