Would like a progress bar for the year, but encountering issues....

[GrahamW]

Howdy, 

Recently encountered a twitter account that I like which posts a progress bar for the year. I would like to make an extension that simulates that, so made a field that displays the day number of the year; specifically: 

DATETIME_FORMAT(NOW(),"DDD")

However, when I am trying to then convert that output into a percentage, I only get an error.

DATETIME_FORMAT(NOW(),"DDDD")/365

I'm very confident there is a simple detail that I am overlooking. Would any of you happen to know why? 

[Sho · Accepted solution]

Hi @GrahamW ,

DATETIME_FORMAT function returns strings value. So strings need to be converted to numbers.

VALUE(DATETIME_FORMAT(NOW(),"DDDD"))/365

[GrahamW]

You Rock! Thanks Sho!