Search the Community
Showing results for tags 'timestamp'.
Found 4 results
It would be great if you could include a button in the Android App, to enter a current timestamp, wherever the blinking cursor is in the note. A simple tap of a button, will allow users to insert a timestamp anywhere within the note. If the note is being continued from an earlier date, then adding a timestamp to the current position of the blinking cursor, will mark that area of the note, with the current time that the note is being updated. Thank you! - Stephen Robinson
Hi folks, I querying the SQLite DB directly and have had some strange encounters with the timestamp fields. From what I can gather they are supposed to be based on the Unix Epoch of 1970-01-01 This timestamp; 736012.8334375 is 2016/02/18 21:00 but trying multiple variants such as select datetime(((((736012.8334375)*1000/60)/60)/24), 'unixepoch'), datetime(((736012.8334375)), 'unixepoch'), datetime(736012.8334375, 'unixepoch'), strftime('%s', 'now'), strftime('7736012.8334375', 'unixepoch'), datetime(736012.8334375, 'unixepoch') Just gives "1970-01-01 02:21:58","1970-01-09 12:26:52","1970-01-09 12:26:52","1464340190",,"1970-01-09 12:26:52" This Excel formula =((((736012.8334375)*1000/60)/60)/24)+DATE(1970,1,1)+(1/24) 4/28/93 5:00 PM Has anyone dealt with this before? Can they shed some light into this hole I'm in Thanks /C
I just noticed a difference in search behavior between Macintosh and Windows and and I'd like to know what folks think about this. I have a saved search called "Daily Review." The search is: [updated:day -tag:call] (the call tag is to filter out phone call records, which come in thanks to IFTTT) On Windows this usually shows fewer notes than on Mac. When I look at the note metadata, I see that on Windows, notes only have a modified timestamp if I actually modified them, while on Mac (and Android FWIW), the modified timestamp appears to be assumed equal to the created timestamp. Here's a screenshot from Windows to illustrate: If I didn't have that call tag, I could change my search to [any: created:day updated:day], but adding in the call tag doesn't work: [any: created:day updated:day -tag:call] returns lots that aren't from today, and that's as expected given the search grammar. Any thoughts on how to approach this?