Display Mysql DAY OF YEAR

I am trying to display the day number of the current year in a MySQL query. like from 1-365. In the dynamic data picker in Database query I have tried lots of different ways.


This is obviously not working. I know the MysQL query is DAYOFYEAR(NOW()), but I have tried this and it didn't work. I am using an update query in my serration action.

Use a custom query and let mysql do it in the SQL query

Great done! In my case I used:

AS concatstring