When using the dateformat function, it would be nice to have more documented options for the data format. For example, there is an undocumented “D” option in the formula that returns the day of the week 1-7.
If there are specific date formats that would be helpful, please add those in the comments of this idea.
I'm looking to determine the day of the week for a custom date field in a calculated column across our features in Aha. We need to report on Preview and GA target dates being set on the weekend so we can work with our PMs to set more realistic dates since we don't do releases on the weekend.
For example when creating custom charts i can take the closed date of a requirement and currently apply the formatting for the month it was closed. it would be really helpful to be able to select weeks instead.