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

[rockeylearning]

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!

[nagakavyasri · Accepted solution]

one way of doing:

[martinding · Accepted solution]

Hi @rockeylearning,

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

[Yoshiro_Fujimori · Accepted solution]

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

[Qiu]

@Yoshiro_Fujimori 
Nice one!

[rockeylearning]

Thank you, everyone! These all are great solutions.