Tag: date

sql server – display date from sql database to datetimepicker C# winform

when storing the date time from the datetimepicker to db i do this piece of code

cmd.Parameters.AddWithValues("@start_date",SqlDbType.Date).Value = txtStartDate.Value.Date;
  • the column type for start_date in sql is date
  • the format for txtStartDate in win-form is Short

so when i want to start displaying the date in the datetimepicker i do this

txtStartDate.Value = Convert.ToDateTime(myreader("start_date"));

but it is unable to display it comes up with an error saying:

“System.IndexOutOfRangeException: ‘start_date'”

magento2 – Catalog price rule remains applied on expired date ranges

I create a catalog rule in my store, and I set a date range.

When this period expires, prices in the store window do not update, only when the customer places the product in the cart. Can anyone help me with this?

I made sure the cron is running every minute.

#~ My Store START

          • /usr/bin/php /var/www/html/mystore/bin/magento cron:run | grep -v “Ran jobs by schedule” >> /var/www/html/mystore/var/log/magento.cron.log
          • sudo /usr/bin/php /var/www/html/mystore/update/cron.php >> /var/www/html/mystore/var/log/update.cron.log
          • /usr/bin/php /var/www/html/mystore/bin/magento setup:cron:run >> /var/www/html/mystore/var/log/setup.cron.log
            #~ My store END

In the table in the database, cron_schedule, all jobs are completed with status ‘success‘.

Well, I can only update the store prices after running the commands:

  • bin / magento indexer: reset
  • bin / magento indexer: reindex
  • bin / magento cache / clean

This store runs with Magento v2.1

Is there a non-coded way to pull last edit user and date into a cell?

Similar to the information as the solution found here. (Is there a quick way to see when a cell in a Google Sheets was last edited?) I would like to populate a cell value with the User who edited the adjacent cell. Is it possible to do this without running code in the background? It seems the info is already present as you can right click and get the data.

Is there a non-coded way to pull last edit user and date into a cell? Google Sheets

Similar to the information as the solution found here. (Is there a quick way to see when a cell in a Google Sheets was last edited?) I would like to populate a cell value with the User who edited the adjacent cell. Is it possible to do this with out running code in the background? It seems the info is already present as you can right click and get the data.

8 – Date Field Type – Text Field Widget is Gone?

I have a use case where the user needs to be able to copy the date
from another source and paste that value into the date field.

This will allow you to paste in and change the date format.

enter image description here

Note: composer won’t install the library for you, you have to manually get the /dist folder from github and put in in the /libraries folder. So it has the /libraries/bootstrap-datepicker/dist/js/bootstrap-datepicker.min.js structure.

Similar but don’t quite do it

Datetime Flatpickr Allows change date format, but doesn’t allow you to type in nor paste.

Bootstrap DateTime Picker Allows you to type in and paste, but doesn’t allow changing the date format.

Single Date Time Picker doesn’t allow you to type in nor paste in nor change the time format.

8 – Date Field Type – Text Field Widget

I am noticing that the Date field type only has the availability of three widgets:

  1. Select list
  2. Date and time
  3. Select list, no time

Can someone tell me why the “Text Field” widget is gone? Or am I missing something?

I have a use case where the user needs to be able to copy the date from another source and paste that value into the date field. It would be too time-consuming to have to pick the date from a “date picker” widget. It would be ok if it were a one-off situation but this user needs to be able to enter several at a time.

javascript – Sharepoint list last modified date

I use this code to get the date of the last edit of a certain list.
Now I want to loop through the listitems and identify the item that was changed last, so i.e. that has the same date as the lastItemModifiedDate()

How you I do this?

Anyone?

ExecuteOrDelayUntilScriptLoaded(Initializeall, 'sp.js');
 function Initializeall()
{

 var ctx = SP.ClientContext.get_current();
 var web = ctx.get_web();
 var lists = web.get_lists();
 var list = lists.getByTitle("Sample");
ctx.load(list, "LastItemModifiedDate");
ctx.executeQueryAsync(
function() {
    var lastmodified = list.get_lastItemModifiedDate();
alert(lastmodified);
},
function() {}
);
}
</script>