How can i calculate the day of the year

where should i add this +1 , please help
yours answer is almost correct

try this…
DAY_OF_THE_YEAR_1(2).aia (2.0 KB)

1 Like

thank you very much @Still-learning

1 Like

How did you overcome the different dates formats that a user might put in textbox ? For example 25/12/2021 or 12-25-2021 ,…etc ?

1 Like

ok, user cannot modify the format of the date ,he will select the date from given list only

1 Like

also you can use any date picker… after picking the date you can set such date in the text box or directly you can show the result…

1 Like

i am testing this procedure now

@dora_paz i tested this procedure is giving the result of the weekday name and that is very great , thanks a lot for yours effort and time given to my question , but i need the which day of the year (which day has two meanings - one is the name of the weekday & second is the number of the day ) my english is little poor …

Try this, it validates date using regex, format should be DD/MM/YYYY otherwise you get notification

DAY_OF_THE_YEAR.aia (9.1 KB)

1 Like

This topic was automatically closed 30 days after the last reply. New replies are no longer allowed.