B4J Question B4XTable, search by date?

One possible solution is to use string fields with string dates.

Sorry, this is only for show - and sort:

also... when setup it...

after setupping like that.... i give it's value (parsing) like "ticks"...

A solution that already do at mine b4xtables... is an extra search textfield... that searching direct the db... So is using ticks for showing into b4xtable... but when I want to search something I search db-table and show only specific rows... (but this only an idea - may be not works for you)

For input data in table I use preferences dialog and there is problem because ...
If I add new record to table using preferences dialog and Table Column ( B4XTable.COLUMN_TYPE_DATE ) it shows
wrong tick value so this option will not work ( unless I input time ticks like item.Put("key", date_string ... )

ticks value is 18h old at the moment you save it ( see 1st post ) at least that's what I see on my PC
( maybe problem is in preferences dialog and some date format or how it set ticks, don't know and for now also less important )

will save it as txt string so search option will work for date also.


Thank you for suggestion and possible solutions.

...If you passed the values/parameters into b4xtable (with column b4xtable1.COLUMN_TYPE_DATE)...

i don't think you ll have problem at showing... using DateTime.DateParse(stringitemyoutakefromanywhere)

but for search as you said.. you must think the way different... may be you can have a column hidden (width:1) with string date too.. (another solution if you don't want an extra textfield for search)

at preferences dialog if using Date Field (Erel's Form Builder json) you set it with ticks for example: (options.put("keyname",datetime.now)

Magma said:

...

at preferences dialog if using Date Field (Erel's Form Builder json) you set it with ticks for example: (options.put("keyname",datetime.now)

Click to expand...

At this point with preferences dialog and date picker ( options.put("keyname",datetime.now) is also not an option, what if user select 'daytime.now <> 2 days ... Ticks value will be saved with time you have entered New values...

Date picker is useless at that point.

...@G-Shadow this was just an example... datetime.now represent a tick value too.. i always preset the values at preferencesdialog before show it...

I know that daytime.now show tick value, but like a wise man said, simplicity is the key
also extra search field as an option, thank you @Magma

G-ShadoW said:

simplicity is the key

Click to expand...

this is certain