0

select

I have a table called vaccinations and i need to get the last date with the vaccination type "influenza"

Select last(vaccinations.vdate) where vaccinations.type="influenza" but this is not working... How do i get the date?

3 replies

null
    • Henrik_B
    • 6 yrs ago
    • Reported - view

    i have also tryed with:

     last(Vaccination.Dato) Where Vaccination.Type Like "influenza" plz help me..

    • Leonid_Semik
    • 6 yrs ago
    • Reported - view

    Hello Henrik

    ---

    max(select vaccination[text(Type)="influenza"].vdate)

    ---

    regards

    Leo

    • Henrik_B
    • 6 yrs ago
    • Reported - view

    thanks.. perfect.

Login to reply

Content aside

  • 6 yrs agoLast active
  • 3Replies
  • 1874Views