MEL Compare Obs Dates

MEL, SQL, Oracle

2 Posts

2 Users

0 Reactions

69 Views

RSS

dmishler

(@dmishler)

Posts: 44

Trusted Member

Topic starter

Hi,
What's the best way to compare the lastobsdate for two different obs terms?

Thanks

Posted : March 17, 2015 12:52 pm

jfitzmd

(@jfitzmd)

Posts: 419

Reputable Member

Function DurationDays(date1,date2)

format date strings as mm/dd/yyyy.

returns string number of days,date2-date1

Posted : March 17, 2015 1:07 pm

Forum Icons: Forum contains no unread posts Forum contains unread posts

Topic Icons: Not Replied Replied Active Hot Sticky Unapproved Solved Private Closed