conditional sentence construction
two conditions in one sentence using would
I want to do calculations with dates and use 'current year' in a formula condition. When I tried to manipulate dates in a formula I always receive an error of incompatibles types; NUMBER AND DATE.   Because of that I had to convert the date fields into numbers in the dataflow. It worked but I didn't resolve the issue of current year because it is impossible to convert a field that change with time. The condition and the formula is the following:  case     when  'Date_Month'+'Date_Year'*12&gt; 2+'current year'*12 then 0 when ('current-'Date_Year')*12+(2-'Date_Month')) % max('Billing_Periodicity') == 0 then 'Parcel_Bill' else 0    Many Thanks for your attention and help NSWindow Mac App Store like Title Bar I've logged in and out, restarted my phone, updated, but the Pokemon footsteps indicating whats nearby wont show up.   The Pokemon still appear in the menu, but I cannot click to select them, nor does it show their distance from me with the footsteps.   What is going on? I found 11 questions like this on gamingSE already, but none of them have proper and up-to-date answers. So I'm creating this Q&amp;A:  How do you either activate a command x seconds/minutes/hours/… in the future or every x seconds/minutes/… in a loop?  Repeating command blocks and ticking functions execute 20 times per second, redstone is  in many situations and most of the extremely fancy solutions, like falling blocks in cobwebs, have broken over time or are needlessly complicated. Quick edit not recorded as such blocking vote change A little background:  I do not know what the specifics are, but I've noticed that a quick edit after a post will often times not result in an edit being posted. It's as if there was no edit. Edit: According to Bart this amount of time is five minutes.  The problem:  A user made a really bad post (said that ~ in C# wrt integers was used for deconstruction). I down-voted said post. Post quickly disappeared (I guess poster realized they screwed up and took back the post). Later, I come back and see my down vote but the answer is now correct (that ~ is the bitwise complement operator). I try to get rid of my down vote because it is no longer appropriate. However, it has been about half an hour and there is no edit posted (presumably the poster made an edit within the non-posting edit window) so I can't take my vote back.  Suggested solution:  If post gets edited (even within the non-post edit window) mark all the votes as changeable. I would guess that this would either involve an update on a table of votes or adding a column for last edit time which is not bypassed by the grace period. I realize that this may be an entirely non-trivial change, but unless the non-posting of edits is somehow changed to make sure the edit was trivial it seems this is necessary. Is there a PPA with the latest version of LibreOffice? There was recently another release of , but it is  a pain to have to manually go to their website and download the packages every time there is a new release. Is there a PPA that always has the latest version of LibreOffice? Difference of Gamma random variables QCompleter Custom Completion Rules Why does ('0' ? 'a' : 'b') behave different than ('0' == true ? 'a' : 'b') Can someone tell me how to get a closed form for  $$\sum_{k=1}^n k^p$$  For $p = 1$, it's just the classic $\frac{n(n+1)}2$.   What is it for $p &gt; 1$? Is there a way to show statistic info? Is there a way to get Statistic info in Blender? Or heads up display? Like when I select a group of vertices, I need a way to know how many vertices are selected and How many polygons "or triangles my scene has. In the following sentence:     The city is populated by many people.   "many" can be replaced by something like "a great number of" (let us leave the perceived differences between the meanings of these two modifiers out of discussion):     The city is populated by a great number of people.   I understand that this replacement does not change the object "populating the city" from the original "people" to a "number", but rather shows the ability of expressions in the form "[numeral] of" to provide information about the quantity of nouns they modify.  Is this ability due to some special qualities of nouns such as "number", "quantity", "fraction", &amp;c., or is it just one usage of the preposition "of"? Let $X$ be a random variable and let $g,f$ be real-valued, nondecreasing, and bounded.   Show that $\mathbb{E}[f(X)g(X)]\geq \mathbb{E}[f(X)]\mathbb{E}[g(X)]$  Having a hard time seeing where to start for some reasons, any hints?  I managed to write:  $\mathbb{E}[f(X)g(X)] = \frac{1}{4}\mathbb{E}[(f(X)+g(X))^2 - (f(X)-g(X))^2]$  But I'm not sure if this is in the right direction or not. Suppose I have a dataframe consisting of six time series. In this dataframe, some observations are missing, meaning at some timepoints all time series contain a NA-value. In R, one possible imputation package that can be used to impute time series data is Amelia. However, this package does not work for observations that are completely missing. Are there other ways to impute my data? For what it's worth, the amount of missing observations is less than 20% of all observations. Clean URLs and php extension on nginx I've looked at dozens of other questions and references on the web - and by all my calculations, my setup should work, but it doesn't.  I have nginx installation with php-fpm.  If I try to access a .php file, it runs correctly and I get the correct results.  I got this in my config file:  location ~ \.php$ {     try_files $uri =404;     fastcgi_pass unix:/var/run/php5-fpm.sock;     include fastcgi_params;     fastcgi_param SCRIPT_FILENAME  $document_root$fastcgi_script_name; }   Now, I want to setup my web app so that /somedir/file automatically executes /somdir/file.php while still displaying /somdir/file in the browser's address bar.  So I modified my config to contain the following:  location / {     try_files $uri $uri/ $uri.php?query_string }   This kind of works, that is, the server does access the .php file.  Yet, instead of executing it using the existing location ~ \.php$ block above, it simply spits the php source code as the download into the browser.  If I append the .php manually to the requested URL, then the php is executed.  It feels as if once the server matches try_files to $uri.php, it then does not do another pass at locations to see that what it needs to do with the php files.  I tried putting the php block above and below the location /, but it makes no difference.  How can I get the php to be executed? Polar form to cartesian Let $\Gamma$ be a circle that passes through the origin. Show that we can find real numbers $s$ and $t$ such that $\Gamma$ is the graph of $r = 2s \cos (\theta + t).$  I know this has to be converted to a cartesian equation, but how do I do this, and what do I do after?  Thanks I have a simple shutdown script which i want to run as root  shutdown -h +30; echo "succesfull";   I have followed these answer, to make my script root.  first I run this command  sudo chown root.root $HOME/test/test.sh sudo chmod 4755 $HOME/test/test.sh   and then made changes in sudoers  sudo visudo   added this command after this line %sudo   ALL=(ALL:ALL) ALL  eka ALL=(ALL) NOPASSWD: $HOME/test/test.sh   But when i executed my script its showing this error  shutdown: Need to be root succesfull Mathematical notation around the world What are the differences in mathematical notation around the world? I know that in some other countries they write 1,2 meaning 1.2, but what else can be confusing in an academic environment (when people are doing math on a board or on paper). How do you start Windows 10 in safe mode? How can I straighten ALL the vertical UV lines at once? Is there a hot keyshort cut? Or if I have to do them one by one .. is there at shortcut for that? Thank you!