About time in transaction

Adrien Monteleone adrien.monteleone at gmail.com
Tue May 30 15:43:03 EDT 2017


> On May 30, 2017, at 2:39 PM, Derek Atkins <derek at 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 <djkurttsang at 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 at 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 at 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
>       derek at ihtfp.com             www.ihtfp.com
>       Computer and Internet Security Consultant
> 



More information about the gnucash-user mailing list