Forum Discussion

4 Replies

    • EnochS's avatar
      EnochS
      Icon for Advocate II rankAdvocate II

      Vvelarde

      Thanks for this! I have used this for 3 different reports so far!

    • DannySoul's avatar
      DannySoul
      New Member

      Hi,

      This solution was very helpful. Previously I created a column my table using TODAY() not in the editor. For my current dashboard it makes more sense to make a few ammendments at query editor level. I have a few questons. 

       

      - Why does the Today() function not work when creating a custom column (query editor) but when I add a date column in my table it does ?

      - Is query level syntax different to the functions syntax used on the tables / columns ?