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 |
|||
« Next Oldest | Next Newest »
|
User(s) browsing this thread: 1 Guest(s)