Sorry, didn't read very carefully...

I think this will do what you want... or most of it.

DECLARE @Date1 DATE = '10-Aug-2015',

@Date2 DATE = '07-Sep-2015'

,@Diff INT

SELECT @Diff = ABS(DATEDIFF(day,@Date1,@Date2));

PRINT @Diff;

the ABS() removes...

For grins, create a dummy table and just copy a bunch of tweet URLs, and see if they work. That's where I got them for my report. If that...

What can't you see?

Sounds like homework. Show us what you tried.

What happened when you ran the query to see if there were any "illegal" hyperlinks?

The INSERT statement should have nothing to do with it, but it's your database,...

Table 1 has "Gender" field with "Male" and "Female" in it, table 2 has "Gender" field with "M" and "F" in it. a query to compare data and list the...

I would write a query against the underlying datasource (table(s)) to see what's going on.

Something like:

SELECT *

FROM TweetsList

WHERE TweetURL NOT LIKE 'http://%'

AND TweetURL NOT LIKE 'https://%'

AND TweetURL NOT LIKE 'ftp://%'

AND...

I don't think so. I did the first one as an embedded dataset and created a union query, just because I wanted the report to be as simple as...

Post if it still doesn't work and explain what you did step by step... because try as I might, I can't reproduce the issue. Can you open the links...

Okay, taking it from the top, because I have no clue why mine works and yours doesn't.

Create a dummy table:

CREATE TABLE TweetsList(

TweetDate DATE NOT NULL,

TweetURL VARCHAR(50) NOT NULL

);

GO

Populate:

INSERT...

I don't have any data... Should I just make some up?

Did you attach it? I don't see it.

Can you post your report with some dummy data? either embed the data like I did or post CREATE TABLE/INSERT scripts to populate it.

The data can be completely fake......

Sure it does. I just did it. It was even easier than I thought.

This is what I did...

(My dataset is embedded, otherwise it wouldn't work for you... it's a...

Is this between a static date, like @CompareDate DATE?

Or is this between sequential Invoice Dates?

Either way you use DATEDIFF, but if you want to look at the previous date, you...