About time in transaction

[Derek Atkins]

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.

> 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