|
|
Archives of the TeradataForum
Message Posted: Tue, 29 Apr 2008 @ 22:08:08 GMT
Subj: | | Case Statement and Crystal Reports |
|
From: | | Chintala, Neetha |
Hello,
I am running a crystal report against Teradata and I have this code in my add command. Can please anyone tell me what is wrong with this case
statement?
(*case* *when* (extract(day *from* current_date)) = 1 *then*
(SNPSHT_DT *between* (add_months((current_date-
extract(day *from* current_date)+1),-1)) *and* (current_date -
extract(day *from* current_date))) *else*
(SNPSHT_DT >(current_date - extract(day *from*
current_date)))*end*)
Thanks in advance for the help,
Neetha
| |