0

date - year - select - vista

Hi everyone, I have a question for you.. if it is possible..

I have a table "PACCHETTI" with a linked-field to another table: "scuderia"  and a date field. Then I've a vista field with this code:

 

 let xscud := SCUDERIA;

 select VISITE where PROFILASSI and PAZIENTI.'LUOGO DI DETENZIONE' = xscud

 

This select statement works correctly and shows a list of specific "VISITE" linked with a specific "scuderia" and with a date.

I would like to have a date field in order to select in the vista field only the "VISITE" happened in that "Scuderia" and in a specific year, ex. 2020.

Is that possible to set the date field in this table with only the possibility to choose a year ?

2 replies

null
    • Fred
    • 3 yrs ago
    • Reported - view

    You can add this line to your VISITE formula to get the data from your current record:

     

    let curRec := this;

     

    Then add this to your select statement:

     

    select VISITE where PROFILASSI and PAZIENTI.'LUOGO DI DETENZIONE' = xscud and [date field from VISITE] = curRec.[date field from current table]

    • saffron_car
    • 3 yrs ago
    • Reported - view

    I'LL try! Many thanks.

Content aside

  • 3 yrs agoLast active
  • 2Replies
  • 319Views