Google Groups no longer supports new Usenet posts or subscriptions. Historical content remains viewable.
Dismiss
Date Difference
88 views
Skip to first unread message
Scott Sandal
Apr 22, 2004, 1:46:15 PM4/22/04
to
I have set my date to mm/dd/yyyy. Within PB script, is there a method to
obtain a date difference as an integer or string. For example, if I have
two variables ld_dt1 and ld_dt2 set to the following, ld_dt1 = 04/22/2004
and ld_dt2 = 06/10/04. Now, I want to know the number of days between these
variables, I would assume I could do a [ ld_dt_diff - (ld_dt1 - ld_dt2) ] or
ld_dt_diff = datediff(ld_dt1, ld_dt2), but neither works. Is there a way
within PB 8.0 that I can easily get this date difference?
obtain a date difference as an integer or string. For example, if I have
two variables ld_dt1 and ld_dt2 set to the following, ld_dt1 = 04/22/2004
and ld_dt2 = 06/10/04. Now, I want to know the number of days between these
variables, I would assume I could do a [ ld_dt_diff - (ld_dt1 - ld_dt2) ] or
ld_dt_diff = datediff(ld_dt1, ld_dt2), but neither works. Is there a way
within PB 8.0 that I can easily get this date difference?
Thank you!
DT
Apr 22, 2004, 1:48:42 PM4/22/04
to
look up DaysAfter function
"Scott Sandal" <Scott....@WellsFargoEFS.com> wrote in message
news:408804e7$1@forums-1-dub...
Ken Balakrishnan
Apr 22, 2004, 2:25:47 PM4/22/04
to
Or for Powerscript, try RelativeDate.
"DT" <david....@integritycompanies.com> wrote in message
news:4088057a$1@forums-1-dub...
DT
Apr 22, 2004, 2:30:49 PM4/22/04
to
I thought DaysAfter was powerscript. RelativeDate won't give the difference
between two dates.
between two dates.
"Ken Balakrishnan" <kNOe...@cps92.com> wrote in message
news:40880e2b$1@forums-1-dub...
Ken Balakrishnan
Apr 22, 2004, 3:47:16 PM4/22/04
to
Oh. Right. Sorry, not paying attention...
Ken
"DT" <david....@integritycompanies.com> wrote in message
news:40880f59$1@forums-1-dub...
0 new messages