Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello,
Sorry if this isnt the best forum to ask this, but Im digging into a SQL data warehouse, which uses a date field. The data is populated from 2004 onwards, but I only want to pull the event data for date rows equal or later than TODAY, and less than or equal to 3 months from now. I can hard code the dates (showm below), but I want this to be automatic and ongoing.
Any ideas?
Here's the hard coded exmaple... Whats the SQL code needed to replace the hard dates with Today until 3 months from now?
select *
from TABLE_DETAILS
where EVENT_CODE = 'XS'
and EVENT_DATE between '01-SEP-16' and '01-DEC-16'
Solved! Go to Solution.
From a purely SQL perspective, you want to use
getdate()
to get the current date/time (convert with a mask to eliminate time if necessary)
and
dateadd(month, 3, getdate())
to get the date 3 months from now (use same convert mask if needed).
From a purely SQL perspective, you want to use
getdate()
to get the current date/time (convert with a mask to eliminate time if necessary)
and
dateadd(month, 3, getdate())
to get the date 3 months from now (use same convert mask if needed).
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |