Post Reply 
Feature requests for Finance application
01-29-2015, 11:40 AM (This post was last modified: 01-29-2015 01:02 PM by Snorre.)
Post: #11
RE: Feature requests for Finance application
Hello Wolfgang (and all others),

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. If I were a key stroke count fanatic I'd put that on a user key anyway.
The Prime is so much different from the older HP calcs that I don't see the point in keeping names for historical reasons. And I'd be happier if "dow" could be used as a local variable name instead of having another short name occupied by a global function; one exception: to me ΔDAYS looks more pleasing than DELTADAYS. It seems that Δ is not taken into account when sorting/searching the catalog (see ΔLIST) so these "DA..."-names would group nicely together.
(But since I do date calculations very seldom if ever I'm biased).

There are some further alternatives for repesenting dates:
- as a single integer 20150129 (no truncated trailing zeroes on 10th, 20th, 30th)
- as a vector/list of integers [2015,01,29] (please not!)
No matter how they're finally displayed, I'd prefer single number/y-m-d order (being consistent with "Date") because it makes comparing/sorting (by sight or in programs/spreadsheets) much easier. I wouldn't call it "american style" (I think "american" would be something were month and date are swapped).

BTW: my Prime crashes when entering {2015,1,28} into the spreadsheet.

IMO day of week should be a single integer where 0=sunday, 1=monday, etc. just because STRINGFROMID(2349 + dow) is shorter than STRINGFROMID(2349 + dow MOD 7).

Greetings
Find all posts by this user
Quote this message in a reply
Post Reply 


Messages In This Thread
RE: Feature requests for Finance application - Snorre - 01-29-2015 11:40 AM



User(s) browsing this thread: 1 Guest(s)