Active Date Counter (Google Spreadsheets)

This is a weird request, but I wanted to see if anyone knew if what I’m asking is possible, and if so how to do it. If you take a look at the image below, you will see the following columns: Steam Name, Server Status, and Date Last Seen.

enter image description here

On another sheet, I am importing the details of a server tracker page, (It shows the details of the game server, like how many people are on it, the map, gamemode etc.) That is shown down below along with a link to the site.

enter image description here

What that sheet (Server Player List) does is that it imports the list of users on the server, then in the Server Status column, if it sees their steam name on the Steam Name column and the Server Player List page, it will mark them as “Online” using the following:

=IF(ISNA(VLOOKUP(D12,'Server Player List'!$ C$ 3:$ C$ 124,1,FALSE)),"Offline","Online")

What I’m trying to do is that if the Server Status is marked as “Online”, it will print the date in the date last seen column. I also want it to stay as that date until it is marked as online again. Meaning I am trying to create an activity tracker, one that will tell me the last time a certain individual logged onto the server. If anyone can help me with this it would be much appreciated.

Change WordPress Published Date every time you click Update

Hi there guys,
I hope you are doing fine…

I remember the time when I found a function somewhere which allowed me to change the published date & time automatically. Every time I went to edit an article, although the content was the same once I clicked on the Update button on WordPress the date and time changed automatically.

I remember that the function was between 5 up to 10 lines.

I hope you can help me.

Kind Regards!

Search Plugin expects different date format in DB – workaround?

I have two plugins: Events Manager and Search & Filter

First one stores dates as YYYY-MM-DD in database, second expects YYYYMMDD format.

What would be an easy workaround to get this working?

First Idea was to let the Events Manager plugin write the date in the correct format in another database table. But I don’t really know where to start.

I know it would be a better solution to get one of the Plugin Developers to support either format – but it seems this won’t happen.

Is transit visa required for my journey via Reykjavik (KEF) where there is a date change during transitioning

I have booked a round trip flight ticket of Wow Air which is via Reykjavik (KEF) airport. My layover details are below:

New Delhi -> Toronto    (2 hrs Layover at  Reykjavik  ) Toronto -> New Delhi    (7 hrs Layover at  Reykjavik  )  

My concern is with the return ticket transit visa requirements (if any). I have read in Iceland visa sites and forums that

“Visa required, except for Holders of confirmed onward tickets transiting on the same calendar day”

My Ticket details are below. There will be a date change while transitioning in my onward ticket in the late night flight. Will it create any issue for me: I am an Indian Citizen and Canada PR? Do i need a transit Visa for any part of Journey? Please help.

Departure: Fri, Mar 22, 2019 New Delhi (DEL) 07:00Toronto (YYZ) 18:00 Flight 1: | 11h 50m | WW323 | Operated by: WOW air Layover: 2h 10m | Reykjavik (KEF) Flight 2: | 6h 30m | WW213 | Operated by: WOW air    Return: Wed, Mar 27, 2019 Toronto (YYZ) 19:00New Delhi (DEL) 03:15 + 2 day Flight 1: | 5h 45m | WW214 | Operated by: WOW air Layover: 6h 55m | Reykjavik (KEF) Flight 2: | 10h 5m | WW322 | Operated by: WOW air 

History table implementation: “Tuple-versioning” vs Effective Date

I’m designing a database that will have history tables (SCD Type 4 I guess) for auditing purpose.

The question is what are the advantages of having tuple-versioning (start and end dates) vs just effective date?

1) tuple versioning

CREATE TABLE HistoryTable (    Column1   Type1,       :        :    Columnn   Typen,     StartDate DATETIME,    EndDate   DATETIME ) 

2) effective date

CREATE TABLE HistoryTable (    Column1   Type1,       :        :    Columnn   Typen,     EffectiveDate DATETIME ) 

For (1) so far I see disadvantages – I have to update [end date] on the previous history record while inserting new/current one.

For (2) I can only insert new record without searching and modification the previous one.

From query point of view both approaches look quite the same.