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.

{{NOW.formatDate(‘yyyy’)+’-’+dayofyear

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.

Community Page
Last updated: