Help

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

Topic Labels: Formulas
Solved
Jump to Solution
1435 2
cancel
Showing results for 
Search instead for 
Did you mean: 
GrahamW
6 - Interface Innovator
6 - Interface Innovator

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? 

1 Solution

Accepted Solutions
Sho
11 - Venus
11 - Venus

Hi @GrahamW ,

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

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

 

See Solution in Thread

2 Replies 2
Sho
11 - Venus
11 - Venus

Hi @GrahamW ,

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

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

 

GrahamW
6 - Interface Innovator
6 - Interface Innovator

You Rock! Thanks Sho!