Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 29 Apr 2008 @ 22:08:08 GMT


     
  <Prev Next>  
<<First
<Prev
Next> Last>>  


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



     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016