sharepoint online – Complicated If statement column format

Try the following:

  "$schema": "",
  "elmType": "div",
  "txtContent": "=if(Number(($SignOutTime))!=0 && Number(($ExitTime))!=0, 'Out', if(Number(($SignOutTime))!=0 && Number(($SignInTime))==0,'Out',if(Number(($ArrivalTime))==0, 'Out', 'In')))",
  "attributes": {
    "class": "=if(Number(($SignOutTime))!=0 && Number(($ExitTime))!=0,'sp-field-severity--severeWarning',if(Number(($SignOutTime))!=0 && Number(($SignInTime))==0,'sp-field-severity--severeWarning',if(Number(($ArrivalTime))==0, 'sp-field-severity--severeWarning', 'sp-field-severity--good')))"

enter image description here

synchronization – Download blocks in blk00000.dat format from a specific period

For study purposes, I would like to download blocks from a specific period, i.e. January 2017 – June 2017, in blk.dat format (blk00000.dat, blk*.dat).

I downloaded blockchain.core but it makes me download the whole blockchain – correct me if I’m wrong.

Also I tried with but the problem is that I can only get one block at a time and just in Json or Hex format – don’t need those.

So, do you know how could I do and with which program or API to use?

I’m a beginner, so please the more details you can give the better it is, even if they seems obvious.

For this work I’m coding in python.

performance – Is it a requirement for an Android Go image to use f2fs format for data partition?

Stack Exchange Network

Stack Exchange network consists of 176 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

ssd – 300GB of phantom data on my Samsung 970 EVO M.2 and no option to format: Is there anything else I can do?

The problem:

So something really weird is going on with my Samsung 970 EVO M.2 SSD. Opening the drive and ensuring hidden files are shown, it’s empty:

screen snip of empty E: directory

but looking in the properties panel it’s also not:

drive properties

(if someone with rep could embed these images it’d be highly appreciated)

So time to try all tools available to figure this out, starting with the basics:

Debugging steps so far:

1. Disk Cleanup

enter image description here

Nothing to gain.

2. Optimize and Defragment

enter image description here

It was worth a shot but no dice.

enter image description here

3. Error Checking

enter image description here

enter image description here

Hmm, that’s a lot of scanning for a drive you’re so sure is empty Windows…

enter image description here

Nothing to see here.

4. Format Drive

If all else fails, let’s just format the dang thing… Right?

apparently I need 10 rep to post more than 8 links
View post on


5. Samsung Magician

Alright no luck yet, but it’s a Samsung drive, so surely if anything can figure this out it’d be a Samsung drive management tool.

apparently I need 10 rep to post more than 8 links
It's midnight why not.

Alrighty then. Apparently Samsung doesn’t fully support this product they sold me.

6. Beg the Stack Exchange gods for guidance

Is there anything else I can do?

seo – HTML Format for a web page

I’m working on my brand new website and I’m trying to make it as optimized as possible mainly for SEO.
In order to reach that goal, I’m trying to do best practices for it’s hierarchy.

My website is hierarchy is as the following:

        <!-- ... -->
        <div id="wrapper">
            <div id="menu">
                    <!-- ... -->
            <div id="content">
                <div id="content-wrapper">
                    <div id="main">
                        <header role="banner"></header>
                        <main role="main">
                                    <h1>Article Title</h1>
                                    <p>Article Description</p>
                                        Text comes here..
                            <section id="global-contact-form">
                                    <!-- ... -->
        <div id="contact-button">
            <!-- This is a fixed block -->

Those are the three dilemmas I’m facing:

  1. Is it correct to wrap my <header>, <main> and <footer> into divs?
  2. Is it right to split the contact form from the article part? (Into the <main> element)
  3. The div#menu is wrapped outside because it’s opening from the side of the screen (using CSS perspective and transform). Did I wrap it correctly, or should I change it to <aside>?

java – Correct format to receive datatime data from consumer

I am working on a service in a sprint boot microservice application. The consumer for my service can be another service, as well as a UI component.

The are 5 entities in my service, each entity having it’s own set of CRUD APIs. Four of these entities have two datetime fields – event_start_date_time and event_end_date_time, where I store date and time without timezone (as it is assumed that the consumer will send datetime in UTC). For ex:


In one of the entities though, only date is needed – start_date and end_date. However, for the sake of consistency, like in other entities, I have been instructed to use datetime here as well. So if the user wants to book something from 2020-01-01 to 2020-01-05, it should be represented like this –


Now my question is, should I expect from the consumer to send the data in above format (appending 00:00:00 and 23:59:59 to the dates)? Or should my service handle this?

If the consumer does this, then he can add some other time as well, like instead of 00:00:00 and 23:59:59, might put 00:00:05 and 14:00:00. My service can ignore consumer’s time input and add correct one itself, but then it would be like discrediting the actual data that consumer has sent.

If my service is to handle it, then the API will only have date and I will be appending time part to it. But this way, it will not be consistent with the other 4 entities.

What can be the best way to do it?

Any other way to do is appreciated as well, just remember that it has to be date and time both.


buy bitcoins – BTC received in BECH32 (P2WPKH) format address not exist in Electrum

I sent some BTC to a BECH32 (P2WPKH) format address. (details of the transaction)

I imported the private key(wif) in Electrum, but I can’t find the income?

I am sure I sent to the right address and imported the right wif. How can I get the incomes?

Thanks a lot!

mysql – Restoring WAMP after accidental format

I have a full backup on my C: drive, this includes the entire directory of WAMP, i have formatted drive C, and then installed WAMP on drive C: in default directory.

Copied and pasted the bin and www directory into the new installation.

Still when i try to log in to SQL i cannot find the SQL database, i get the following error when trying to visit the URL
Error establishing a database connection

Can anyone please advise how to restore WAMP.


Perl Time::Piece use current date if not in format

Consider this code:

use Time::Piece;
my $format="%I:%M %p";
my $from="9 am";

my $d_from = Time::Piece->strptime($from, $format);
print ($d_from);

This prints:

Thu Jan  1 09:00:00 1970

Let’s assume I cannot change $format or $from . The format may or may not have d/m/y values -> how do I make sure the converted object uses current date/time values for the missing components?

My usecase is this: I am writing a rules engine where a user specifies an arbitrary date/time format and I need to match rules if they fall in that date/time. Since the use controls $format and $from I don’t know if $format will contain a day/date. It may just contain a time. When converting to a Time::Piece object I want to make sure missing fields are replaced with current date/time not start of epoch time.

formatting – Exapanding and Sympifying expression when using typesetting format

I’m starting to learn Mathematica, and in the book that I’m reading the author presented the commands “Simplify” and “Expand”. Now, the example in the book was the following:

Simplify((x^3 - y^3)/(x - y))

Now, this commend works, and outputs $x^2 + x y + y^2$. The problem is, if I use the
typesetting notation, the function doesn’t actually work:

Simplify($frac{x^3 – y^3}{x-y}$)

The above command outputs $frac{x^3 – y^3}{x-y}$, instead of the simplified form. The same happens for the command “Expand”.

Is there a way around this? As asked in the comment, here is the output of

Simplify($frac{x^3 – y^3}{x-y}$)FullForm

RowBox({"Times", "(", 
RowBox({"Power", "(", 
RowBox({"Plus", "(", 
RowBox({"x", ",", 
RowBox({"Times", "(", 
RowBox({"-", "1"}), ",", "y"}), ")"})}), ")"}), ",", 
RowBox({"-", "1"})}), ")"}), ",", 
RowBox({"Plus", "(", 
RowBox({"x\.b3", ",", 
RowBox({"Times", "(", 
RowBox({"-", "1"}), ",", "y\.b3"}), ")"})}), ")"})}), ")"}),