What's the `date` of a tblorders?

[malin]

What's the `date`  of a tblorders? 

 

mysql> select * from tblorders limit 1;
+----+------------+--------+-----------+---------------------+-------------+----------------+----------+-----------+-----------+------------+-----------+--------+---------------+-----------+-----------+-----------------+-------------+-------------+-------+
| id | ordernum   | userid | contactid | date                | nameservers | transfersecret | renewals | promocode | promotype | promovalue | orderdata | amount | paymentmethod | invoiceid | status    | ipaddress       | fraudmodule | fraudoutput | notes |
+----+------------+--------+-----------+---------------------+-------------+----------------+----------+-----------+-----------+------------+-----------+--------+---------------+-----------+-----------+-----------------+-------------+-------------+-------+
| 15 | 9306257830 |      3 |         0 | 2020-01-01 00:03:41 |             |                |          |           |           |            | a:0:{}    |   0.00 | alipay_full   |         0 | Cancelled | 110.184.220.250 |             |             |       |
+----+------------+--------+-----------+---------------------+-------------+----------------+----------+-----------+-----------+------------+-----------+--------+---------------+-----------+-----------+-----------------+-------------+-------------+-------+

 

Whether the `date` is the order created date?  today  there is no new order,   but there have today's ` date`  orders.

 

[WHMCS Sachin]

2 hours ago, malin said:

What's the `date`  of a tblorders? 

 

Whether the `date` is the order created date?  today  there is no new order,   but there have today's ` date`  orders.

That is correct. "date" is indeed the order created date. It is strange that you are seeing today's date on the order but no orders for today in the admin area. Can you please check Order 15 and see what date is it showing in the admin area?