• From: Pakistan, Karachi
  • Registered: 03/03/2015
  • Posts: 654

Topic: Date and Time in Date_row

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

www.boxygen.pk

boxygen's Website

2 Reply by poncho1234 (edited by poncho1234 07/05/2018 05:44:09 pm)

  • From: Colombia
  • Registered: 12/29/2014
  • Posts: 629

Re: Date and Time in Date_row

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

The FrontAccounting Wiki(Manual, examples, tips, setup info, links to accounting sites, etc) https://frontaccounting.com/fawiki/
  • From: Pakistan, Karachi
  • Registered: 03/03/2015
  • Posts: 654

Re: Date and Time in Date_row

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.

www.boxygen.pk

boxygen's Website

  • From: Colombia
  • Registered: 12/29/2014
  • Posts: 629

Re: Date and Time in Date_row

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

The FrontAccounting Wiki(Manual, examples, tips, setup info, links to accounting sites, etc) https://frontaccounting.com/fawiki/
  • From: Pakistan, Karachi
  • Registered: 03/03/2015
  • Posts: 654

Re: Date and Time in Date_row

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

www.boxygen.pk

boxygen's Website

6 Reply by poncho1234 (edited by poncho1234 07/06/2018 03:42:26 am)

  • From: Colombia
  • Registered: 12/29/2014
  • Posts: 629

Re: Date and Time in Date_row

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() {
The FrontAccounting Wiki(Manual, examples, tips, setup info, links to accounting sites, etc) https://frontaccounting.com/fawiki/
  • From: Pakistan, Karachi
  • Registered: 03/03/2015
  • Posts: 654

Re: Date and Time in Date_row

Quite difficult for me to edit Javascript sad

www.boxygen.pk

boxygen's Website

  • From: Colombia
  • Registered: 12/29/2014
  • Posts: 629

Re: Date and Time in Date_row

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?

The FrontAccounting Wiki(Manual, examples, tips, setup info, links to accounting sites, etc) https://frontaccounting.com/fawiki/
  • From: India, TN, Karur
  • Registered: 05/16/2014
  • Posts: 1,195

Re: Date and Time in Date_row

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.

Subscription service based on FA
HRM CRM POS batch Themes

kvvaradha's Website