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

What is the difference between hashfile and sequential file?

987


How to Remove Duplicate using SQL?

1100


What are the some differences between 7.x and 8.x version of datastage?

1039


Differentiate between data file and descriptor file?

840


what is flow of project?

1792


What are the benefits of datastage?

982


How you can fix the truncated data error in datastage?

1470


tell me 5 situations when we r using oracle db stages like orecle connector, oracle enterprise

2953


What are the types of containers in datastage?

971


Define meta stage?

1017


for example You have One Table with 4 Columns (Mgr ID, Department ID, Salary, Employee ID). Can you find out the Average Salary and Number of Employee present per Department and Mgr

1096


I have a few records just I want to store data in to targets cycling way how?

2160


client know skid info?

1893


Can you explain engine tier in information server?

921


What is a quality stage in datastage tool?

875