timestamp on AddTransaction

[Walking with me]

I have WHMCS set on localisation to YYYY-mm-DD

In our API call which has been working for years,  as YYYY-MM-DD. I upgraded to PHP 8.2 FPM and WHMCS 8.13.1 (from 8.11), and now the date in the DB is the date of the API call and not the date I am sending in the postdata. 

I tried changing the date format in settings/general/localisation

I have timezone in php set to Africa/Johannesburg

 

Am I chasing my own tail or is there a regression

 

I see in the changelog there is Correct date timestamp of refund transactions (Also known as: CORE-19688)

thanks

[WHMCS John]

Hi @Walking with me,

1. Which API command are you experiencing this with?

2. Which parameter is affected? Please can you provide an example of the current data and for comparison the format you were expecting.

[Walking with me]

17 minutes ago, WHMCS John said:

Hi @Walking with me,

1. Which API command are you experiencing this with?

2. Which parameter is affected? Please can you provide an example of the current data and for comparison the format you were expecting.

1.  AddTransaction

2. the date sent is now current date time and not value sent 

 

 

[Walking with me]

1 hour ago, WHMCS John said:

Hi @Walking with me,

1. Which API command are you experiencing this with?

2. Which parameter is affected? Please can you provide an example of the current data and for comparison the format you were expecting.

Post Data: array(11) {
  ["identifier"]=>
  string(32) "....1"
  ["secret"]=>
  string(32) "C....O"
  ["action"]=>
  string(14) "AddTransaction"
  ["responsetype"]=>
  string(4) "json"
  ["userid"]=>
  string(1) "1"
  ["amountin"]=>
  string(4) "1.00"
  ["date"]=>
  string(10) "2025-07-03"
  ["credit"]=>
  string(4) "true"
  ["description"]=>
  string(15) "ImportST: blha2"
  ["transid"]=>
  string(46) "1098B5B1-856B-1B0E-18A6-657B2FC10318"
  ["paymentmethod"]=>
  string(12) "banktransfer"
}

tblaccounts:

id    userid    currency    gateway    date    description    amountin    fees    amountout    rate    transid
2257    1    0    banktransfer    2025-07-07 17:45:48    ImportST: blha2    1.00    0.00    0.00    1.00000    1098B5B1-856B-1B0E-18A6-657B2FC10318

tblconfiguration

id    setting    value    created_at    updated_at
15    DateFormat    YYYY-MM-DD    NULL    2025-07-06 22:05:10

 

the date is the date of the api call not the transaction date, worked fine in previous versions.

[Walking with me]

On 7/7/2025 at 4:14 PM, WHMCS John said:

Hi @Walking with me,

1. Which API command are you experiencing this with?

2. Which parameter is affected? Please can you provide an example of the current data and for comparison the format you were expecting.

any ideas please?

[pRieStaKos]

Use Carbon for setting the formatting, in your code (https://carbon.nesbot.com/docs/#api-formatting)

Provide example to assist you any further.