> On May 30, 2017, at 2:39 PM, Derek Atkins <de...@ihtfp.com> wrote: > > Hi, > > On Tue, May 30, 2017 3:23 pm, Adrien Monteleone wrote: >> Kurt, >> >> While officially there is no way to record times in transactions, you can >> use the NUM field to some degree for this purpose. >> >> Either you can enter simply increasing digits to order your transactions >> outside of the order in which they were entered, (1, 2, 3, etc.) or you >> can use this field as a time stamp. I’ve switched to this time stamp >> method when entering many transactions and not sorting my paperwork >> beforehand. I use 24 hour time without any spaces or delimiters for this. >> So for your example of an expense to McDonald’s for Food:Breakfast, I’d >> enter 0800 in the NUM field. If I later stopped at Starbucks because I >> didn’t care for McDonald’s coffee, I might enter say 0830 in the NUM field >> for that transaction. This will give me the time and order the >> transactions by that time as a bonus. >> >> I’m not sure if the “:” delimiter for time is allowed in the NUM field, I >> don’t need it and haven’t tried it. > > It is "allowed" in the sense that the NUM column is just a string entry > field, so any character is allowed. However, the sorting of the num > column is performed numerically, so the string is converted to an integer > and then sorted. That means that any non-numeric character is "stop" to > integer conversion. I.e., 08:00 and 08:30 will both convert to the > integer '8' and sort equally. Whereas 0800 and 0830 will convert to the > integers 800 and 830 and will sort accordingly. > >> I suppose if you didn’t want to use 24 hour time, you could preface the >> time with “A” or “P” (or their lowercase equivalents) and GC will sort >> them appropriately. Be sure to put the A or P in front and not at the end >> or you’ll end up with 800A and 800P right next to each other with say 830A >> following. Sorting is by character in order left to right. > > No, it wont. 800A and 800P will sort the same. And 800A will sort AFTER > 100P. See above.
Apologies. I assumed it as an alpha-numeric sort. I didn’t realize it was integer. I guess then 24 hour format (without delimiters) is the way to go. > >> Hope that helps, >> >> Adrien > > -derek > >> >> >>> On May 28, 2017, at 12:00 PM, Kurt Tsang <djkurtts...@yahoo.co.jp> >>> wrote: >>> >>> I'd like to know is it possible input the time in transactions? It's >>> really important for me to track the history...... >>> For example "2017-04-01 08:00" paid to McDonal for Food:Breadfast. >>> >>> And is it possible have a web version? >>> Thanks a lot >>> >>> iPadから送信 >>> クルト・ソン >>> _______________________________________________ >>> gnucash-user mailing list >>> gnucash-user@gnucash.org >>> https://lists.gnucash.org/mailman/listinfo/gnucash-user >>> ----- >>> Please remember to CC this list on all your replies. >>> You can do this by using Reply-To-List or Reply-All. >> >> _______________________________________________ >> gnucash-user mailing list >> gnucash-user@gnucash.org >> https://lists.gnucash.org/mailman/listinfo/gnucash-user >> ----- >> Please remember to CC this list on all your replies. >> You can do this by using Reply-To-List or Reply-All. > > > -- > Derek Atkins 617-623-3745 > de...@ihtfp.com www.ihtfp.com > Computer and Internet Security Consultant > _______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org https://lists.gnucash.org/mailman/listinfo/gnucash-user ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.