Skip to main content
Solved

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

  • October 11, 2023
  • 2 replies
  • 21 views
GrahamW
Forum|alt.badge.img+12

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? 

Best answer by Sho

Hi @GrahamW ,

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

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

 

2 replies

S
Forum|alt.badge.img+21
  • Sho
  • Inspiring
  • Answer
  • October 12, 2023

Hi @GrahamW ,

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

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

 

GrahamW
GrahamW
Forum|alt.badge.img+12
  • GrahamW
  • Author
  • Known Participant
  • October 12, 2023

You Rock! Thanks Sho! 

 

Terms & ConditionsAccessibility statement