• rafat
  • Senior Member
  • Offline
  • From: UAE, Dubai
  • Registered: 11/28/2017
  • Posts: 540

Topic: Print Statements (rep_108) Date

The date on rep_108 always picks the server date (hosting server). I have specified the time zones in

.htaccess
config.php
/includes/date_functions.inc

all to be Asia/Dubai.. still rep_108 shows the system date and not the timezone date.

Attached screen shots.

Any suggestions on how to correct this to show the timezone date?

Post's attachments

FA_Date.zip 18 kb, 4 downloads since 2020-03-12 

You don't have the permssions to download the attachments of this post.

rafat's Website

  • From: Vietnam
  • Registered: 09/28/2016
  • Posts: 349

Re: Print Statements (rep_108) Date

This occurs when php date and mysql date are not the same.
You can add this code right below line 127 of rep108.php to make the report get the php date instead of mysql date:

$rep->formData['document_date'] = date2sql(Today());

Or somehow synchronize php date and mysql date in the data manipulation functions.

Phuong

notrinos's Website

  • rafat
  • Senior Member
  • Offline
  • From: UAE, Dubai
  • Registered: 11/28/2017
  • Posts: 540

Re: Print Statements (rep_108) Date

Thanks @notrinos
Your code addition works.

rafat's Website

  • rafat
  • Senior Member
  • Offline
  • From: UAE, Dubai
  • Registered: 11/28/2017
  • Posts: 540

Re: Print Statements (rep_108) Date

Sorry @notrinos

I was looking at a different system when I posted the above.

adding

$rep->formData['document_date'] = date2sql(Today());

did not help resolve the issue.

rafat's Website