Question Re: How to caluculate difference in days between two dates in Product Lifecycle Management Q&A

How to caluculate difference in days between two dates

Former Member — Sun, 23 Sep 2007 16:15:08 GMT

Hi guys,

Can you please give suggestion how to find out the difference between two dates(difference should be in number of days)

I tryed by the fallowing expression bellow

datediffdatediffdays(Repeater_0.Output{/Row/afd} , Repeater_0.Output{/Row/sfd} )

afd and sfd are two dates.

afd and sfd are Data types of Date

when i Evaluate it was given error in valid date format parameters used as parameters

xMII datasource is MySQL database.

please guide me.

Thanks

Srikanth M

Re: How to caluculate difference in days between two dates

Former Member — Sun, 23 Sep 2007 19:36:13 GMT

Did you try executing the transaction?

Probably you will not see this error @ run time as the Dates would have some values.

Re: How to caluculate difference in days between two dates

jcgood25 — Sun, 23 Sep 2007 19:44:56 GMT

Srikanth,

Evaluate will not work in this case because it really only has the column knowledge at design time (not the actual row of data that it will have iteratively at runtime).

The function name in your post looks like a typo (datediffdays is the right name), and if you want to see it work put the expression in a tracer and hit F6.

With your datasource being a relational database you would have a similar function in sql which is <a href="http://datediff">http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html</a>

Depending upon your needs you may be better off doing the datediff function in your SQL Query template and not in BLS.

Regards,

Jeremy

Re: How to caluculate difference in days between two dates

salvatore_castro — Tue, 25 Sep 2007 15:46:59 GMT

Try formatting the Repeater_0 values to <b>XML Dates</b> first...as of now they are just <b>strings</b>.