Exploring, modeling, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Date Differences

Accepted Solution Solved
Reply
New Contributor
Posts: 3
Accepted Solution

Date Differences

Hi to all,

I am trying to calculate the difference in days between two date fields. Is there any way to do this on report level ?

Thanks in advance.


Accepted Solutions
Solution
‎01-28-2015 08:30 AM
Regular Contributor
Posts: 196

Re: Date Differences

Hi Vangelis,

Happy to hear that, please mark the question as answered.

Thanks,

Teja Surapaneni

View solution in original post


All Replies
Regular Contributor
Posts: 196

Re: Date Differences

Hi,

Can pls tell me bit more u want no.of days or DOD growth

New Contributor
Posts: 3

Re: Date Differences

No, I just want the difference in days just like in excel.

I could not find an appropriate function to implement this.

Thanks

Regular Contributor
Posts: 196

Re: Date Differences

Just convert the date fields to numeric (using treatas function), after that u can easily get solution.

Regular Contributor
Posts: 173

Re: Date Differences

Teja, vtsit

correct, that works well  Smiley Wink

pic1.png

This also covers the year skip, that would not have been solved while using days(Del.Date)-Days(entry.Date)

greeting

New Contributor
Posts: 3

Re: Date Differences

Hi all,

thanks for the replies, I finally managed to solve the problem due to your suggestions.

Thank you so much.

Best regards

Vangelis

Solution
‎01-28-2015 08:30 AM
Regular Contributor
Posts: 196

Re: Date Differences

Hi Vangelis,

Happy to hear that, please mark the question as answered.

Thanks,

Teja Surapaneni

☑ This topic is SOLVED.

Need further help from the community? Please ask a new question.

Discussion stats
  • 6 replies
  • 593 views
  • 1 like
  • 3 in conversation