FrontAccounting forum — Date and Time in Date_row

Re: Date and Time in Date_row

null@example.com (kvvaradha) — Mon, 09 Jul 2018 01:47:09 +0000

Time functionalities are not programmed in existing FA. If you wish to use date and time picker you need to find a JavaScript or jQuery plugin to use and then you need to disable the FA date picker and use the new one. But you have to change some programs to maintain FA date formats into the new plugin formats.

Re: Date and Time in Date_row

null@example.com (poncho1234) — Sat, 07 Jul 2018 16:00:25 +0000

My js is non-existent, I had a quick look at datepicker / time picker libraries (there's lots)... its not a simple mod.

What exactly do you want to achieve?

Re: Date and Time in Date_row

null@example.com (boxygen) — Sat, 07 Jul 2018 14:16:50 +0000

Quite difficult for me to edit Javascript

Re: Date and Time in Date_row

null@example.com (poncho1234) — Fri, 06 Jul 2018 03:37:44 +0000

I would start here:-

File: \includes\ui\ui_view.inc

969: function get_js_date_picker()

And
File: \includes\ui\ui_view.inc

1247:   function calendarDrawTable() {

Re: Date and Time in Date_row

null@example.com (boxygen) — Fri, 06 Jul 2018 02:30:20 +0000

Yes, I want to input time manually. What could be the changes?

Re: Date and Time in Date_row

null@example.com (poncho1234) — Fri, 06 Jul 2018 00:27:54 +0000

I may have led you astray a little - sorry

Something like -

datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP

Should give the time when you select the date from the datepicker

But do you want to input the time manually? I believe you will still need datetime but also changes to core

Re: Date and Time in Date_row

null@example.com (boxygen) — Thu, 05 Jul 2018 23:40:42 +0000

I tried changing the datatype of the field from date -> datetime in mysql. It gives me two options (ON UPDATE) AND (CURRENT TIMESTAMP). I tried both cases

After changing this data type the behaviour of FA remains unchanged while the value being stored at database is like this
2018-07-04 00:00:00

No input is taken from FA for the Time.

Re: Date and Time in Date_row

null@example.com (poncho1234) — Thu, 05 Jul 2018 17:41:34 +0000

What happens if you change the data type from 'date' to 'datetime' or 'timestamp'? MySQL
Not sure how FA will read stored value though???

Date and Time in Date_row

null@example.com (boxygen) — Thu, 05 Jul 2018 17:20:14 +0000

Using Date_row function with date picker can we input both Date and Time?