Feature requests for Finance application

[ggauny@live.fr]

(03-07-2015 07:04 AM)BruceH Wrote:  

(01-29-2015 11:40 AM)Snorre Wrote:  I'm fine with the longer but easier to remember names (DAYOFWEEK, DATEADD). I think DATEDAY (Does it return the day-part 1..31 of a date?) is not as obvious as DAYOFWEEK.

Sorry for being a bit late to the party here, but I agree with DATEDAY being the day number. So why not have DATEDOW, DATEDAY, DATEMON (or DATEMONTH) and DATEYEAR to return the relevant day of week, day number, month number and year?

Instead of DELTADAYS, I suggest DATEDIFF - then all the date functions start with the word "DATE" and they're all together in the catalog.

Very good idea, i agree.