August 7, 2013 at 8:23 am
Hi I am trying to get my date from 2011-01-01,Please help
August 7, 2013 at 8:30 am
I'm sorry, but can you reword that question? I don't understand what you're looking for and I don't understand what that has to do with the topic of Date Incrementing.
For best practices on asking questions, please read the following article: Forum Etiquette: How to post data/code on a forum to get the best help[/url]
August 13, 2013 at 2:36 pm
Extremely vague, but perhaps:
DATEDIFF function
DATEADD function
might help you.
SQL DBA,SQL Server MVP(07, 08, 09) "It's a dog-eat-dog world, and I'm wearing Milk-Bone underwear." "Norm", on "Cheers". Also from "Cheers", from "Carla": "You need to know 3 things about Tortelli men: Tortelli men draw women like flies; Tortelli men treat women like flies; Tortelli men's brains are in their flies".
August 14, 2013 at 1:23 am
What i mean is to get my date from 2011
for example if i say skDte >= Getdate() i don't have to go back to my code and change it each time my report run it will give me current info
thats what i want get info current info starting from 2011
Hope i explained it
August 14, 2013 at 1:35 am
Still not clear. How about this?
skDte >= '20110101'
If that's not what you require, please supply table DDL (CREATE TABLE statement), sample data (INSERT statements) and expected results.
John
August 14, 2013 at 1:36 am
kgeeel240 (8/14/2013)
What i mean is to get my date from 2011for example if i say skDte >= Getdate() i don't have to go back to my code and change it each time my report run it will give me current info
thats what i want get info current info starting from 2011
Hope i explained it
Not really, do you want data from a static point in time in 2011 or is this date calculated somehow based on todays (the day the report is run) date?
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply