AnsweredAssumed Answered

How to check the "NA" date and delete it in Saleforce?

Question asked by cjitpongumpai917281 on Sep 3, 2018
Latest reply on Sep 4, 2018 by kartikay.nagal147205

I will pull data out from Saleforce and group all data by using the UserID.

For the single record I will transfer it to Database file directly. 

But, for all group records I will check weather there are "NA" in the date filed or not, if it is there I want to delete that row. 

 

Example:

UserID      Date

121A         10/10/17

124A          NA

122A         14/08/15   

123A          20/07/18

122A         12/11/14

123A          NA

 

 

 

 

Result:

UserID      Date                

121A         10/10/17    

         

122A         14/08/15             

122A         12/11/14

 

123A          20/07/18     

        

124A          NA                       

 

Could anyone give me some suggestion please? 

 

Best Regards,

Chaya

Outcomes