calculation in script

[#1]

Hi,

In the script i have 'date of joining' and 'date of seperation', can i calculate the 'vintage' in the script itself?

Regards,

Rahul

[kaushiknsolanki]

Hi,

     You can use Interval() and Interval#() function for that.

      Look into Help for more details.

     Hope this will help you.

Regards,

Kaushik Solanki

[erichshiino · Accepted solution]

I am not sure how you calculate it (the expression for it) but you could create any field as an operation of other fields, during reload...

For example, if your code is similar to this:

load ID, Joining_Date, Separation_Date from....

You can create something like this:

Load ID,Joining_Date, Separation_Date, Separation_Date- Joining_Date as Duration from...

(that gives you the difference in days)

Hope this helps,

Erich

[#4]

to slightly modify Erichs answer

if(isnull(Separation_Date),today(),Separation_Date)-Joining_Date

if there is no separation date then use todays date.

in days.

[#5]

Erich,

thanks for the reply... it worked

Thanks