Skip to main content

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? 

Hi @GrahamW ,

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

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

 

You Rock! Thanks Sho! 

 

Reply


Terms & Conditions