Hi Brendan,
1. WEEK NUMBER OF THE YEAR
There is already a function on TF that gives us the week number of the year.
It’s a great feature because it allows us to summarize work done, sales, or whatever we need by week.
2. DAY OF THE WEEK
I’ve been looking for a function that, given a date, returns the day of the week, but I found none.
Is there any way on TF of getting the day of the week, for a given date?
If not, would it be possible to implement such a function?
Hi Jose,
1. That’s a beta version feature right now.
2. Do you mean Monday, Tuesday, Wednesday, etc? Or do you mean a number value between 1 and 7?
Thanks,
Brendan
I mean Monday, Tuesday, …
If we need a short version, like “Mon”, I think you already have some string function able to give us the first N characters of a string.
Thanks.
You can already do that by using the DATE() function.
For example:
DATE(Date Field, "EEEE")
Will give you just the day of the week in full. If you want a partial word for the day name, then you can use fewer E’s.
See this link for more date patterns:
http://www.unicode.org/reports/tr35/tr35-31/tr35-dates.html#Date_Format_Patterns
And remember to set the Result Type to Text on the Formula Edit screen.
Thank you very much for your help.
.
