Forum Discussion
Uno1283
Nov 17, 2023Copper Contributor
Script help
Hi all
i am hoping someone can help me.
the script below does not work. Can someone help me please?
select *
from
(
select *, convert(varchar,[updatedat],3) as [updatedatdate)
from tlbReopen
) at table1
where datediff(mom,[updateatdate], getdate ()) <=1
1 Reply
Sort By
- LainRobertsonSilver Contributor
Hi, Gary.
There's a lot of syntax errors there and for some we can only guess what you might have intended.
Here's my best guess based on what you've provided:
SELECT * FROM ( SELECT * , CONVERT(varchar, [updatedat], 3) as [updatedatdate] FROM [tlbReopen] ) AS [Table1] WHERE DATEDIFF(mm, [updateatdate], GETDATE ()) <=1
If this isn't what you were after, then can you please provide the following so we have a better idea of what you're trying to do and what you're working with:
- Details of the error - i.e. include the exact message;
- Example data from tblReopen (it doesn't have to be real values, but we need to see samples);
- For the final "DATEDIFF" line, tell us which date part you're hoping to use, as "mom" is not valid;
- If you can put your code in a code box, that makes it easier for us to read.
Cheers,
Lain