Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

how to find diff between 2 dates without using Icon...
funtions?

Answer Posted / subbuchamala

This function returns number of days from source date to the given date.

DaysSinceFromDate(mylink.sourcedate, mylink.givendate)--->No of days.

Ex:
DaysSinceFromDate(“2014-06-10”,”2014-06-15”)= 5

Is This Answer Correct ?    2 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to manage date conversion in Datastage?

1177


What are transforms and what is the differenece between routines and transforms?

1103


how to export or import the jobs in .ISX file

1248


Define orabulk and bcp stages?

1170


Can you explain players in datastage?

1245


How to find value from a column in a dataset?

2249


how can we create rank using datastage?what is the meaning of rank?

8846


Distinguish between informatica & datastage. Which one would you choose and why?

1039


Where the datastage stored his repository?

1133


What is a merge in datastage?

1341


Notification Activity

1456


How to reverse the string using unix?

3586


What is the method of removing duplicates, without the remove duplicate stage?

1073


1)s.key generate 1 to 700 records today. tomorrow another 400 will updated how to update the records using s.key generator? 2)source is like :-- DB --> T/F stage1 --> seq1file T/f 1 is linking with T/F2 ---> seq 2 how to load the data? in source i given some conditions those r going in seq1. The another data will going to seq2 how to do this ?

2074


Is possible to create skid in dim,fact tables?

2689