Need Days from two Dates

[krisp321]

Hi
I am trying to get no. of days from two dates.

Source dates
Date1 Date2
10/23/2010 10/25/2010
10/20/2010 10/22/2010
10/19/2010 10/22/2010

Read as varchars and converted to date format using stringtodate func.
Now Date1 and Date2 are date datatypes
Date1 Date2
2010-10-23 2010-10-25
2010-10-20 2010-10-22
2010-10-19 2010-10-22

Now in transformer
if i do
Date1-Date2 to get no. of days
output is Integer
I am getting an error
Invalid consertion from date to dfloat

any suggestion is greatly appreciated

Thanks in advance
Kris

[swapnilverma]

plz try below function

DaysSinceFromDate

It Returns the number of days from source date to the given date
source_date given_date

Let us know if u face any issue ?

[krisp321]

hi
I tried, I did not get expected result
here is what I tried
DaysSinceFromDate(Date1) - DaysSinceFromDate(Date2)

[anbu]

Code: Select all

DaysSinceFromDate(Date1,Date2)

[naveen.p]

Hi,

anbu Wrote
--------------------------------------------------------------------------------

Code:
DaysSinceFromDate(Date1,Date2)

---------------------------------------------------------------------

DaysSinceFromDate(Date Column, Format Specifier).

Can we mention a second date to find the difference?

Thanks
Naveen

[anbu]

Yes

[krisp321]

Code: Select all

DaysSinceFromDate(Date1,Date2)

I tried but this is not working. I am just getting 0 days. I am not getting exact days. I am trying to load the difference into integer datatype. Does this makes any diff.?

[mailravi.dw@gmail.com]

I am assuming Date1 and Date2 attributes are varchar and provided the below Derivation.

Derivation: DaysSinceFromDate(StringToDate(Date1,"%mm/%dd/%yyyy"), StringToDate(Date2,"%mm/%dd/%yyyy"))

This function returns the interger (int32) value.

[naresh_kakarla]

convert date formate to integer format by using juliandays from date and then you use '-' operator

[chulett]

So, what was your actual resolution?