Questions tagged [date]

A date is a reference to a particular day represented within a calendar system, and consists of year, month and day.

Filter by
Sorted by
Tagged with
0 votes
1 answer
27 views

Change Magento My Order 2.4.4 Date Format

at following path i'm trying to change date format /app/code/Magento/Sales/view/frontend/templates/order/history.phtml https://imgur.com/jOQNshk from 3/6/22 to 03/06/2022 How can i edit following code?...
user avatar
0 votes
1 answer
148 views

Custom Sorting option not working in Magetno 2.4 search

Custom Sorting option not working in Magetno 2.4 search app/code/Arun/NewSorting/etc/di.xml <?xml version="1.0"?> <config xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance&...
user avatar
  • 526
0 votes
0 answers
46 views

Magento 2 Add Custom date filter in UI Grid

I have created a custom grid for my custom table. It has a created_at column. Now I want to filter the entries by 7 days, 30 days, 90 days. ie, a dropdown with options 7days, 30 days, 90 days. How do ...
user avatar
1 vote
1 answer
175 views

Magento 2.4.2 invalid date format by default, can't change date format in UI component

I would like to specify the date format for a new date field in my CMS page form. I have created a new cms_page_form.xml field which links to a date field in the MySQL database table cms_page. However,...
user avatar
0 votes
1 answer
144 views

Magento 2 Admin Orders Date show not actual result

I have Magento 2.4.2-p1 EE. When i filter orders by dates, example: Purchase Date: 12/12/2021 - 12/12/2021 I have result with 777 found orders. But on last page i can see orders with wrong dates for ...
user avatar
0 votes
1 answer
62 views

Magento 2.4.x add datetime field in design configuration form using ui component

In Magento 2.4.x, How to add date time field in Content -> Design -> Config-> HtmlHead. I tried the below code it is showing in UI(design_config_form.xml) but it is not saving. <field ...
user avatar
  • 1,094
0 votes
0 answers
18 views

Create Invoice and Shipment with Backdated Date

We have quite a few orders that we need to create invoices and shipments for that. How can we create them with dates in the past? If we generate them on the backend it uses today's date.
user avatar
0 votes
0 answers
16 views

Magento2: Show FedEx all methods estimate shipping date

I am using Magento2.3.3 version. And I need to show the FedEx Estimate Date beside the FedEx Lable on the checkout page. Any API for this? Like this: Help would be appreciated.
user avatar
  • 1,749
0 votes
1 answer
159 views

Magento2.3.4 different hours in REST API call GET Orders and the real order hour timezone

I have selected Timezone (Configuration->General->Locale Options) Central European Standard Time (Europe/Warsaw) Order 10004 has been created at: Sep 21, 2021, 5:59:34 PM When I send API ...
user avatar
0 votes
0 answers
26 views

Magento2 - How to add custom product attribute of type is Only Year field?

Greeting of the day! As per our requirement wise, I need Custom Product attribute and their type is the only YEAR field, so that how can I create the date year attribute only allow to select the year, ...
user avatar
1 vote
0 answers
24 views

date range validation in magento 2 ui comonent

I have created a custom module to mark order as delivered , In my ui component file located at app/code/Namespace/Modulename/view/adminhtml/ui_component/namespace_delivery_form.xml i have the ...
user avatar
0 votes
0 answers
21 views

Product import - Dates need to be US style?

I am trying to set up Product imports for a UK client for Magento 2.4.2 and am finding that the Special To and From Dates need to be set up US style, eg, mm/dd/yyyy rather than UK style, eg, dd/mm/...
user avatar
0 votes
0 answers
44 views

Magento 2 - Incorrect updated_at value for quote session

im using Magento\Checkout\Model\Session to get the current quote on the cart. $quote = $this->checkoutSession->getQuote(); $updated_at = $quote->getUpdatedAt(); my problem is the update_at ...
user avatar
  • 133
0 votes
3 answers
302 views

Magento 2 : Ui component displaying wrong date

So I created a module where I am storing order details in custom table and later on displaying all the details in custom grid. Everything is working fine except for date field. In the database its ...
user avatar
0 votes
1 answer
46 views

Converting this date format 2021-04-26 05:31:38 to 26 Apr, 2021 in magento 2

How can we Convert this date format 2021-04-26 05:31:38 to 26 Apr, 2021 in Magento 2. Please let me know how can I do this.
user avatar
0 votes
2 answers
450 views

Sort products by date Magento 2.4.1

$this->_collection->addAttributeToSort('created_at', 'DESC'); // not working $this->_collection->setOrder('created_at', 'DESC'); // not working //$this->_collection->setOrder('...
user avatar
0 votes
0 answers
21 views

Magento2 change time for datepicker

Currently, time for Holiday time picker is [from] => 2021-03-24 00:00:00 [to] => 2021-03-24 00:00:00 Need to change to [from] => 2021-03-24 00:00:00 [to] => 2021-03-24 23:59:59 The ...
user avatar
  • 3,446
0 votes
4 answers
208 views

how to use date() in magento query?

I want to filter some orders based on the date range so in SQL i use this query SELECT * FROM `sales_order` WHERE date(created_at) >= '2020-12-02' AND (date( created_at) <= '2020-12-...
user avatar
0 votes
2 answers
396 views

How to get date of tomorrow in magento2

How can I get date of tomorrow in Magento2? I can use below code to get current date but I couldn't fetch the date of tomorrow. // $this->datetime \Magento\Framework\Stdlib\DateTime\DateTime $...
user avatar
0 votes
1 answer
683 views

Magento 2.4 Sort products by date

I've found topics about enabling sorting by date, this being one example but on 2.4 this does not work, even manually typing ?product_list_order=created_at in url does not get any results, is there ...
user avatar
0 votes
1 answer
99 views

Change display month on select box

I have a module and a select box for display month. In file download.phtml, I mentionn value month and I want display that are 01, 02, 03, ..., 12. How can I do that?
user avatar
1 vote
0 answers
20 views

M2 - Weird coupon date change on save

Magento version: 2.3.4 When I create a new shopping cart price rule (coupon code) and choose a date range like this: Then in the coupon overview list I see this date: So that correct, but when I ...
user avatar
  • 573
0 votes
2 answers
435 views

Notice: A non well formed numeric value encountered

I'm trying to format the DB timestamp to 'm:d:y, something like 07/06/20`. Please change the piece of code below to help achieve it. echo $dbh->Record['fulfillmentDate']; Returns 2020-07-02 02:...
user avatar
0 votes
1 answer
295 views

Count only business days, without weekend and holidays

I have the current date, in the format I need: Y/m/d And I need to calculate what date will be in X days excluding weekends and holidays. X - because this value is dynamic and can be set in the admin ...
user avatar
1 vote
1 answer
1k views

Magento 2.3 - Transactional email remove time from order date

How can we remove the time in the order created date inside the transactional email? We now load it like this; {{var created_at_formatted}} and displayed as: 9 apr. 2020 11:17:59 We want to remove ...
user avatar
  • 1,474
1 vote
0 answers
197 views

Magento 2.3.4 Change date picker to 3 drop down dd/mm/yyyy

How to change Magento 2 date picker to 3 drop down which allows users to pick date month and year. Tried to follow this -> DOB Validation with three fields in magento2 But it didn't work and it wasn't ...
user avatar
0 votes
1 answer
139 views

How to render date field in UI component (in php not xml) in magento 2

How to render date field in UI component(in php not xml) in magento 2 I am building form as in the catalog (meta arrays), datetime eav attributes. I have tried like below 'date_of_stock' => [ ...
user avatar
  • 2,398
0 votes
1 answer
295 views

magento 2.3 overide date calendar class

I am trying to override a date calendar class in Magento. But when I try doing it the date input from the product page disappears. Basic I want to override the date calendar script to add custom ...
user avatar
0 votes
0 answers
717 views

Importing Date Attributes in DD/MM/YYYY format

When importing products with date fields in format dd/mm/YYYY it throws this error: Value for 'special_to_date' attribute contains incorrect value in row(s): 1, 2, 3 From reading around I see ...
user avatar
  • 1
0 votes
1 answer
764 views

convert any date into dateTimestamp in order to compare it

I’m trying to compare the current date timestamp with product special price end date. to get current date I use : $currentDate = Mage::getModel('core/date')->timestamp(time()); and for ...
user avatar
0 votes
1 answer
2k views

How to put correct date on invoice PDF in Magento 2?

Invoice PDFs are generating the incorrect date, I have this on two sites both on 2.3.4 and en_GB locale e.g. $order->getCreatedAt() 2020-02-14 11:14:40 becomes $this->_localeDate->formatDate( ...
user avatar
2 votes
0 answers
36 views

Disable a dropdown based on Date attribute

I have created a 2 date attribute which is Date_from and Date_to via back-end. Admin can add these dates and related time slots in another drop-down attribute which is choose_date. In the frontend, ...
user avatar
  • 31
0 votes
1 answer
573 views

Magento2 Order Date is Wrong in Admin Grid

We created an order in magento2 with API calls. It is working fine as expected . We have created_at field date as 23-01-2020 12:12:12 in database where as in admin magento2 order grid it is ...
user avatar
1 vote
0 answers
97 views

import date format correct in magento 2

i'm tring to import a date field correct into the special_from_date and special_to_date field of products however for some reason the result is not correct. I have this -<Item> <sku>...
user avatar
  • 21
1 vote
0 answers
34 views

Report interval date column issue - M2

Admin panel > Reports > Products > Ordered It's magento's default report and result data is showing in 3rd date it's actually of 4th date. Issue is, Data is showing in one day previous in grid. ...
user avatar
1 vote
1 answer
263 views

Magento 2.3 get current local time in phtml

I want to load the current local time in a custom phtml file, that I want to load in my CMS Page. I currently have the following code but that loads the GMC time, not my local time. How can I change ...
user avatar
  • 1,474
0 votes
1 answer
1k views

Magento 1.9 - How to get shipped date and display on Customer account My Order?

Backend generate date when we shipped order, Frontend shown only order created dated, Is it possible using event-observer?
user avatar
  • 95
1 vote
0 answers
216 views

Magento 2 get current time and week days

I use the following code in my Magento 1 store, but I want to convert it to Magento 2. I load this in a custom .phtml file to display on a CMS page. How can rewrite the following for Magento 2? CODE:...
user avatar
  • 1,474
0 votes
1 answer
191 views

Date format issue to save giftcard Lifetime in Magento 2

I am creating giftcard code programmatically. For this in vendor GiftCardAccount Module, the code is: $model = $this->giftCAFactory->create()->setStatus( \Magento\GiftCardAccount\...
user avatar
  • 1,521
1 vote
1 answer
355 views

Date format missing in admin grid and admin form in magento 2 custom module?

I created a custom module to update news and stories to magento 2 website.I have the date field in my form( main.php ). $dateFormat = $this->_localeDate->getDateFormat( \...
user avatar
  • 2,577
0 votes
1 answer
67 views

Store time in js

I need to use current store timestamp in js or phtml file, how can always have current store date-time or timestamp when phtml is cached and I cannot pass this variable to js. Any help will be very ...
user avatar
1 vote
0 answers
279 views

JSON Serialize DateTime in Web API

A lot of my Web API interfaces use DateTime return types or parameters as follows. interface TestInterface { /** * @param \DateTime $value * @return void */ public function ...
user avatar
  • 11
2 votes
2 answers
939 views

Magento 2 - Admin grid and export use different timezone

I'm using Magento 2. So, I created a Adminhtml data grid in a custom module. The problem is that the data grid doesn't match the exported data. I've set the timezone, but it seems data grid and ...
user avatar
1 vote
2 answers
2k views

Change order date to invoice date on invoice PDF in Magento 2

How to change the order date in the invoice PDF in Magento 2 to invoice date? I think it's done in the AbstractPdf.php file, but cannot get the right code to pull the right data. It's shown in the ...
user avatar
2 votes
2 answers
488 views

How to over ride php file in magento 2.3

I want to do some changes in vendor/magento/framework/Stdlib/DateTime/Date.php How can I override the file in app folder?
user avatar
  • 700
2 votes
3 answers
214 views

M2 - Change end date of all coupon codes

In the database there is a table called salesrule_coupon which has all the coupon codes in it. I need to change the column expiration_date for all the coupons to the same date 30-08-2024, Is This ...
user avatar
  • 573
1 vote
2 answers
992 views

M2 | How to configure store's timezone to set date as I am getting wrong date in magento?

I get different date from todays date. I tried below ways and all give difference in time: 1) \Magento\Catalog\Block\Product\Context $contexts, .......... .......... $this->...
user avatar
  • 1,521
1 vote
1 answer
425 views

Get current date and time in custom module and save that in database in magento 2

I wanted to get the current date and time as created_at. I have tried all the ways I found on google but nothing works for me. It showing error while running my module. use Magento\Framework\View\...
user avatar
  • 23
1 vote
0 answers
38 views

Magento 2 warning on select date on frontend

Does anyone encounter this warning when choosing a date, please help me fix it. thank you.
user avatar
  • 641
0 votes
1 answer
67 views

Invoice Date sets to 1 Jan 1970 when set to "Paid"

Does anybody please know why some invoices on Magnento 1 are automatically reverting to 1 Jan 1970 for the purchase date and due payment date when they are set to paid? Many thanks in advance
user avatar
  • 1

1
2 3 4 5