WEEKDAY function not found

Hello Folks,

I want to return the current date as an index. So, I was using the weekday function WEEKDAY(NOW( )).
But whenever I execute the query, I was getting the function not found error. Can anyone of you suggest me how to enable these functions so that I can use them.

1bb87faf-c377-4abb-8419-f6fa8eb96a3d.png

Any help will be highly appreciated.

Thanks in advance!!

 

0 1 133
1 REPLY 1

Also attaching my code for your reference. 
Suggest me if there are any errors in my code or some other way where I can return the current day index. 

9cce4e75-e561-4284-a3f5-171d447d2a81.png
Top Labels in this Space
Top Solution Authors