Suggestions for show how many days? Passing the International Date Line

Little background Let’s say you fly from the United States to Japan and suppose you leave the United States on Tuesday morning. Because you’re travelling west, the time advances slowly thanks to time zones and the speed at which your aeroplane flies. But as soon as you cross the international dateline, it’s suddenly Wednesday.

Below image from google flight, which is +2 means taking 2days gap. this +2 doesn’t make a sense for me.

enter image description here

Is filtering on int better than filtering on date

I have a system where most of our table has the current datetime as primary key and we filter most of the data based on the datetime.

The question, if I move this datetime to another new table and have an auto id in the new table. for eg.

Dates id datetime 1  11/6/2019 2  11/7/2019 3  11/4/2019 4  11/8/2019 

Now all the other tables will have id instead of datetime and filtering will be based on the id.

Will this improve performance or filter on a datetime is equal to filter on int?

I am using SQL Server 2018.

On what date do the events of the Lost Mine of Phandelver adventure happen?

I bought the D&D 5e Starter Set a few weeks ago, and I’m beginning to think about how to drive the scenario as I’ve already read it and I’m at the stage to get familiar with the rules.

Yesterday I created my first character sheet with one of my future players (we’re not going to use pre-generated sheets) and we talked about his character’s lore and background – he will be playing a nobleman, a prince).

I thought that there could be a king in Neverwinter (the closest bigger city to the location of the adventure) , so we could link his background to the scenario. Again, his character would be the son of a king, who, after finishing his Paladin training, wants to go an on an adventure to gain experience and prove his value and that he is adequately trained to potentially govern one day.

However, when I searched for Neverwinter lore, I found out that while there were indeed kings, they didn’t exist towards the end of the timeline.

Given that, I tried to find out at which date the events of LMOP take place, but I didn’t manage to find it anywhere in the books.

So, based on already existing modules or deductions based on facts in existing modules, when do the events of LMOP take place?

If the date is deducted instead of directly stated somewhere, you have to support your answer with official sources, not just a more or less educated guess. The better the answer is supported by sources, the better.

Convert Date to a format

I am trying to call REST API based on a date query.

my filter string is

$ filter=Created le ‘2019-04-28’

however, Instead of the date value, I need a dynamic date of todays minus 180 days and in the right format.

I was able to get the 180 days before by adding -180 days to the date variable.

But the date I get is in

“4/28/2019”

format.

Any suggestions on changing the / to – and changing the position of M,D,Y ?

Calculated Column Field Date

I need to calculate date based on other column I’m using =Date(Year([endDate]),1,1) in a calculated field which needs to return data as DateTime, but it is giving me error:

The formula contains a syntax error or is not supported.

After that I tried to modify the view to take only the year from today date as a string like: Trim(Text(Year([Today]))) and it is accepting the formula, but no results in the view.

Any suggestions what can be causing the problem? I prefer to make it work like in the 1-st option which I described, but if it is doable in the 2nd, it is also acceptable.

Help with date list validation and blank fields

New to Sharepoint trying to find my way:)

I have the following structure : StartDate1,EndDate1,StartDate2,EndDate2 StartDate1 and EndDate1 are mandatory fields. StartDate2 and EndDate2 are not. Iā€™m trying to create a list validation where if Start date 2 contains data EndDate2 cannot left Blank (and vice verca) and at the same time for both Start End Date columns , End dates are not earlier than Start Dates

Any assistance will be highly appreciated Thanks all!

SQL Query- field calculation based on date

I’m writing a query for sales targets per week, however I’m getting a little stuck on this. Targets are per month, per year, so for example, Brand A has a monthly target (changes each month)

The snippet from the report is as follows: SELECT BrandName ,SUM((TargetMonThur *4) +TargetFriday) WHERE [MONTH] IN (DATEPART(MM,@DAY1),DATEPART(MM,@DAY2),DATEPART(MM,@DAY3),DATEPART(MM,@DAY4),DATEPART(MM,@DAY5)) AND [YEAR] IN (DATEPART(YY,@DAY1),DATEPART(YY,@DAY2),DATEPART(YY,@DAY3),DATEPART(YY,@DAY4),DATEPART(YY,@DAY5)) However the issue appears when the start of the week/ end of the week is a different month to the other days. at this point, it calculates both month’s targets * 4.

I think I’m being a complete noob on this, but any help would be great.

Thanks in advance

Calculated column with multiple options depending on start date of event compared to today

I’m attempting to create a column (“30, 60, 90, +”) that reports if an entry is within 30, 60, or 90 days out. One field is “Start Date” and I want the field to report ’30’ if the start date is within 30 days from today, ’60’ between 31-60 days from today, and ’90’ for between 61-90; with ‘+’ being the entry beyond that timeframe.
Is this doable?