Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Date script

Status
Not open for further replies.
itguymike

itguymike

Technical User
May 27, 2005
28
US
hello,
i am trying to update a time field in a table and am having issues. what i am trying to have happen is to update any desired_rls_date fields to be 2/18/2014 that are equal to or before the date below (2/18/2014)

UPDATE WORK_ORDER
SET DESIRED_RLS_DATE='2/18/2014'
WHERE DESIRED_RLS_DATE =<'2/18/2014'

i get an error with the less then sign.

any help would be appreciate.
 
Sort by date Sort by votes
Change [!]=<[/!] to [!]<=[/!]

The less than symbol must appear before the equal sign.

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

leifoet
  • Locked
  • Question
How te filter by date ?
Replies
9
Views
195
dhookom
dhookom
peac3
  • Locked
  • Question
Derive staus date time by aligning start and end datetime
Replies
7
Views
298
Andrzejek
Andrzejek
Cpreston
  • Locked
  • Question
Last date per userid 1
Replies
3
Views
129
Andrzejek
Andrzejek
niall5098
  • Locked
  • Question
Create plan guide with date time parameters
Replies
3
Views
123
Chris Miller
Chris Miller
ahmedsa2018
  • Locked
  • Question
How to get monther per part id from last date to current date and include remaining date ? 1
Replies
7
Views
170
JohnBayne
JohnBayne

Part and Inventory Search

Sponsor

Back
Top