Graphics

 View Only
  • 1.  Search within XLS file trough datalink

    Posted 03-09-2020 14:31

    I've connected a XLS file trough datalink with a couple of fields:

    date, info 1, info 2

    01-01-2020, test 1, test 2
    02-01-2020, test 11, test 22
    02-01-2020, test 111, test 222

    How can I select one row, from this xls file, where I can select the info from one date? For example 02-01-2020 or the date of today? Can I do this in the scene director?



  • 2.  RE: Search within XLS file trough datalink

    Posted 03-10-2020 07:56

    update:
    I'm using datalinq to import a Xls-file and adding

    how can I filter here a date? 

    This doesn't work. Does datalinq support the "Date" query?

    SELECT Blad1.[Huidige datum]
    FROM Blad1
    WHERE (Blad1.[Huidige datum])=Date();

     

     


    #XPression