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

Define meta stage?

1200


What are the steps required to kill the job in Datastage?

1212


how to export or import the jobs in .ISX file

1190


how to achieve this output ? Two Input columns(ID & Name) - ID | Name 1 | Jack 1 | Kara In output there should be only 1 column which will be populated as - 1,Jack 1,Kara

799


What are the different type of jobs in datastage?

1040


How many types of views are there in a datastage director?

1280


What are the difference types of stages?

1204


Differentiate between operational datastage (ods) and data warehouse?

1172


Could anyone give brief explanation bout datastage admin

2350


What is use Array size in datastage

1774


how do u catch bad rows from OCI stage? And what CLI stands for?

2795


What is aggtorec restructure operator?

1432


What is the Environment Variable need to Set to TRIM in Project Level?(In transfermer, we TRIM function but I need to impliment this project level using Environment variable)

2377


Describe the architecture of datastage?

1001


What is size of a transaction and an array means in a datastage?

1303