LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: gauravdb

Hi,

I have a data that looks like this:

Create_Date:String
01-02-2013
01/02/2013
1/2/2013

I would like to convert the column to DATE type but the problem is that it has few different types of dates. How do I use the function override emit 'Create_Date'.date("D/M/CCYY") as "Create_Date" ???

I keep getting the error because of different types of date in the dataset.

Thanks
G.K

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: ltolleson

I would first normalize the field using the replace() command.

tempDate = Create_Date.replace("-", "/").replace(".", "/")

You should make sure to cover all the different formats contained in the data.

Next you can check the value before you actually do the conversion to make sure that all data can be converted.

if tempDate.isDate("D/M/CCYY") then
newDate = tempDate.date("D/M/CCYY")
else
newDate = null #or whatever you want to do with dates that cannot be converted.

emit *
override emit newDate as "Create_Date"

Hope this helps.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: gauravdb

Thanks Larry,

Yes, it did change the slash to hiphen. I can see all the results with slashes now, BUT when I am trying to run it, it stills says CANNOT CHANGE 01-02-2013 to the specifiied date type....

Not sure why.

G.K.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Tim Meagher

If you used the code in the previous post, this was changing all hyphens to slashes, and then performing the conversion not the other way around.
What brainscript code are you using exactly?
It sounds like you are replacing all slashes with hyphens and then trying to convert to a date where the date format string is expecting slashes.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: gauravdb

Hey, Sorry about the confusion, I mean hipen to slash.

I get this error

ERROR processing data:
cannot parse value '03-02-2013' with format 'D/M/CCYY'
2014-08-20 10:27:31.000; WARN: cannot parse value '03-02-2013' with format 'D/M/CCYY'
id: 0 chain: 0 group: 0
cppDetail: context: parseDate() build/linux-x86-64/release/code/source/brain/expert/ToDate_ExprOp.cpp@179

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Tim Meagher

Can you post the brainscript you are using?

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: gauravdb

newdate= 'Resolved_Date'.replace("-","/")
emit *
override emit newdate as "Resolved_Date"

override emit 'Resolved_Date'.trim.date("D/M/CCYY") as "Resolved_Date"

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: gauravdb

Let me clear few more things:

I have two columns "Create date" and "Resolved date", if I use the same filter to change the data type of these two columns from STRING to DATE , it is giving me the error as mentioned above. But if I Use two different filters, there is no error.

Thats Odd??

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: Tim Meagher

			
				newdate= 'Resolved_Date'.replace("-","/")
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

			
				override emit newdate as "Resolved_Date"
			

This line is changing the hyphens in the field "Resolved_Date" to quotes and storing the result in the variable "newdate".
The field "Resolved_Date" is unchanged.

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: gauravdb

Thanks a TON!!!

That solved the confusion and the column is finally changed to DATE type

Thanks
G.K