cruising – What are the requirements for a tourist in a hire car crossing over in to Palestine from Israel for the day?

Gov.uk

I consulted Gov.uk regarding the question i am asking but i find their explanation extremely inconclusive.

Question

So, on November 23rd i will likely be easy jetting to Greece to catch a November 24th Mediterranean cruise which includes two days in Israel.
We arrive in Ashdod on day 5 and on day 6 the cruise arrives in Haifa. So what i plan to do is take an extended shore tour and hire a car from Ashdod and drive to Jerusalem and then cross over in to Palestine at Lifta and then take road 60 back in to Israel en route to Nazareth and Bethlehem before heading to a hotel in Haifa in order to get back on the cruise ship the next day.

However i am not sure about how easy it will be to cross in to Palestine, as i know the political situation in this region is very awkward.

Is my route plan and itenary possible? What crossing points should i use? Apart from my passport and car log book, what other documents will i require?

How to automatically fill, sort and conditionally format 1st day of the week according to given year and month in excell?

I previously had the answer in Google sheet environment
How to automatically fill, sort and conditionally format 1st day of the week according to given year and month. I would like to do it in Excel but the function (sequence) is not valid .. Any thoughts?

Is chrome vulnerable to any zero day exploits right now?

i was using flvtbo youtube converter and i had to enable javascript.

i saw an ad come up from “multiadblock.com” which tried to lure me into downloading a chrome extension, but of course i didn’t even proceed

after browsing through the google extension store i noticed that no such extension exists.

flvto even redirected me into their website. which did not even load(because i have javascript disabled :p)

However. i did have javascript enabled for flvto to pop the the malicious ad.

As to what the website actually contains . Obviously the website is malicious

custom javascript – List Dates Off by One Day

I am having issues with dates in a SharePoint 2013 list.

At a high level I am archiving the dates of the selected item in List1, storing them in List 2. The dates in the selected item are updated to new dates with my code.

Seems when I retrieve the dates from List1 using a REST call I get the proper date back. I am converting the date to a MM/DD/YYYY format and then storing it in List2 but the List2 date is off by one.

The argument isoDate is the value from the REST response so the value I am getting from REST looks like “2020-02-17T06:00:00Z”. List1 date is 2/17/2020. So all good.

The return (mydate) is 2/16/2020 and this value is getting stored into List2 and also displayed on my custom form…but it’s wrong!

I could add one day to the date but that is likely not the solution here. Not sure why that return date is getting reduced by one day and how to resolve it.

Thanks.

GetDate: function (isoDate) //3.5 namespace addition
    {
        
        var testdate=new Date(isoDate);
        var mydate=moment(testdate).format('MM/DD/YYYY');
        
        return mydate;

I have looked at other posts but they have not been useful.

indian citizens – Arrival and departure on same day to/from India

I’d like to travel to India from Ireland and back to take my son with me from India. Under the current restrictions, will it be possible to arrive and depart on the same day, provided I am able to get a flight back on the same day of arrival without leaving the airport? I’m planning this as I don’t want my wife and new born alone in Ireland for a week or so during my quarantine.
Thanks in advance.

microsoft excel 2010 – I need to have the “year” convert to this calendar year 2021 while maintaining the day and month

Eg. 09/25/2003 would need to reflect 09/25/2021. Each cell has a different date associated with a “policy” so I’d like a formula that will change just the “year” to reflect this calendar year 2021. Essentially, read the “year” and add the appropriate number of years to equal 2021, then return the value (cell) to reflect the same day/month with updated year.

mysql – Get the quantity of sold products on a specific day, keeping all products

I’m building a database for daily sales report, for example:

2 apples sold for 2.50 on 2021-02-12
1 apple sold for 2.00 on 2021-02-12
6 bananas sold for 3.50 on 2021-02-12
0 pears sold on 2021-02-12

Notice the “0 pears sold”

I have these tables:

Products

id (PK) name deleted_at
2 Apple null
5 Banana null
6 Pear null

Orders

id (PK) sale_date (DATE)
1 2021-02-12
2 2021-02-12

ProductOrders
|order_id (FK)|product_id (FK)|quantity|price|
|1 | 2 (it is “Apple”) | 2 | 2.50 |
|1 | 5 (it is “Banana”) | 3 | 3.50 |
|2 | 2 (it is “Apple”) | 1 | 2.00 |
|2 | 5 (it is “Banana”) | 3 | 3.50 |

I would like to get the products sold on 2021-02-12 grouped by price, keeping products that have not been sold so that I can write “0”, as in the example.

I tried this query:

SELECT
    p.id AS prod_id,
    p.name AS prod_name,
    sum(po.quantity) AS quantity_sold,
    po.price AS price
FROM products p
    JOIN ProductOrders AS po ON p.id = po.product_id
    JOIN Orders AS o ON po.order_id  = o.id
WHERE o.sale_date = THE DATE
GROUP BY p.id, po.price
ORDER BY p.name, po.price

With this query I get:

2 apples sold for 2.50 on 2021-02-12
1 apple sold for 2.00 on 2021-02-12
6 bananas sold for 3.50 on 2021-02-12

Without the “0 pears sold”, because the query discards the products that have not been ordered in “that date”

How can I to edit this query to get all products, also if they has not been sold in the date? Because I need to write 0 for the products has not been sold in “that date”

Thank you in advance and sorry for my bad english

I forgot to say that I tried to use LEFT JOIN, but the problem is that in this way, it will keep all orders

SELECT
    p.id AS prod_id,
    p.name AS prod_name,
    sum(po.quantity) AS quantity_sold,
    po.price AS price
FROM products p
    LEFT JOIN ProductOrders AS po ON p.id = po.product_id
    LEFT JOIN Orders AS o ON po.order_id  = o.id AND o.sale_date = THE DATE
GROUP BY p.id, po.price
ORDER BY p.name, po.price

This query will keep all “ProductOrders” so it will returns many many rows, so I can’t use this solution