Finding Total Number of Day based on provided Date using RegEx?

Hi!

Is there a way to find total number of day of the year based on the provided date? For example, if today is 4/20, then the number of day so far is 110 of 365, if 4/21 then 111 and so on.

I can use datediff to find the number of day, but since I don't have a begin date (or two date to begin with), and the year will change as time change, so how do I find this with regex?

Thank you in advance for your help!

Workflow

Accepted answers

one way of doing: Screenshot 2023-04-20 175313.png

No. of days till today.yxmd

Hi @rockeylearning,

I am not sure how to calculate this in RegEx, but you can definitely try this DateTime functoin approach:

YearToDate.yxmd

Yoshiro_Fujimori

Hi @rockeylearning ,

You can also use Specifier "%j" in DateTimeFormat() function.

https://help.alteryx.com/20223/designer/datetime-functions#specifiers

Sample Workflow

Formula

DaysOfYear = ToNumber(DateTimeFormat([Date],"%j"))

Output

DaysOfYear.yxmd

All comments

one way of doing: Screenshot 2023-04-20 175313.png

No. of days till today.yxmd

Hi @rockeylearning,

I am not sure how to calculate this in RegEx, but you can definitely try this DateTime functoin approach:

YearToDate.yxmd

Yoshiro_Fujimori

Hi @rockeylearning ,

You can also use Specifier "%j" in DateTimeFormat() function.

https://help.alteryx.com/20223/designer/datetime-functions#specifiers

Sample Workflow

Formula

DaysOfYear = ToNumber(DateTimeFormat([Date],"%j"))

Output

DaysOfYear.yxmd

@Yoshiro_Fujimori
Nice one!

Thank you, everyone! These all are great solutions.

Quick Links

Tags

This months top contributors

atcodedog05 19598

Qiu 15867

MarqueeCrew 13708

apathetichell 13703