0

Problem: Function is not define: contains (date,strings)

let me := this;

(select 'Control Issues')[contains('Rev A', me.'Issue by Rev') and Date >= me.'Week Start' and Date <= me.'Week Finish']

The 'Rev A' is a Date and the 'Issue by Rev' is a text Field 

2 Antworten

null
    • Ninox-Professional
    • planoxpro
    • vor 1 Jahr
    • Gemeldet - anzeigen

    Hello Rafael, I don't understand why you want to compare a date with a string, but try using text('Rev A'). If "Week Start" and "Week Finish" are numeric fields, then week(Date) might also help.

      • Rafael_Sanchis
      • vor 1 Jahr
      • Gemeldet - anzeigen

      planox. pro Thanks works 👍, appreciate your help.

Anmelden, um zu antworten

Content aside

Kategorien

Alle Themen anzeigen
  • Status Answered
  • vor 1 JahrZuletzt aktiv
  • 2Antworten
  • 36Ansichten
  • 2 Folge bereits