Assistance needed on a script for a business filing system

[penntwin99]

I am working in a google document spreadsheet to make a list of active customers. I am attempting to create a script that when a completion date is entered, that row (all the customer info) is transfered to another sheet and/or deleted. I started a script but it isn't working properly.

function myFunction() {
'var ssdate = spreadsheet.column B'
// the "if" clause : if (date = 1) {
// the "then" clause : then ( move row to sheet 2)
}

Since this is my first time, I am sure this needs some work, but any help would be greatly appreciated.

[EpicWebDesign]

Can you post a link to a sample sheet (fake data is fine) but just so we can see what you are working with? Also, are you acessing this and then trying to run the script from your server? I have written many scripts for clients that do just what you are trying to do (basically archive completed jobs), however your question is a bit vague so I'm unsure as to how/where you need the calculations made and where/how you want that info stored.

[felgall]

if (date == 1)

or even

if (date === 1)

should fix it. With just one = it is assigning 1 to date instead of comparing them.

[penntwin99]

thank you