Day of the Year

• 

  Tiffanie Staver

  • October 26, 2022 20:11

  Kimberly commented  ·  March 19, 2015 7:57 AM

  Hello John,

  You could accomplish this using a modified datedif() formula. You can determine the first of every year with the following formula:

  year({Date})&"/"&"01"&"/"&"01"

  This will extract the year of your date field, then concatenate the first month and first day of the year so the output would look as follows: YYYY/MM/DD.

  You would then insert this as the Start Date in a datedif() function. Because this function returns a number between two dates, you would need to add one to the final result. The end result might look similar to:

  datedif({Date}, year({Date})&"/"&"01"&"/"&"01", "d")+1

  Hopefully this helps! Please let us know if you run into further issues.

  Thank you,

  Kim

  0
• 

  Tiffanie Staver

  • October 26, 2022 20:12

  John McGarvey commented  ·  March 19, 2015 10:49 PM

  Thanks Kim - works perfectly.

  0

Please sign in to leave a comment.