Number of days since <relevance that returns date>

Content Authoring
1

I’m trying to get the the number of days that has passed since a date thats returned from relevance and now, something like:

current date - "Sat, 08 Aug 2015"

but I’m getting an error “Singular expression required”, presumably because it thinks the relevance might return multiple answers. The relevance I’m using to return the date is:

current date - (maxima of ( (it as date ) of ( ((it as integer as string) of preceding text of last "/" of following text of first "/" of it ) & " " & (preceding text of first "/" of it as integer as month as three letters)& " " & "20" & (following text of last "/" of it as integer as string)) of preceding text of first " " of following text of first "I " of it) of lines whose (it contains "Completed backup to") of files whose (name of it as lowercase contains "history.log.0") of folders "/Library/Logs/CrashPlan" as string)

How would I modify this to return number of days?

Thanks!

1 Like
2

use maximum instead of maxima to get the singular and then cast to date so you can use the - operator

Q: current date - ((maximum of ( (it as date ) of ( ((it as integer as string) of preceding text of last "/" of following text of first "/" of it ) & " " & (preceding text of first "/" of it as integer as month as three letters)& " " & "20" & (following text of last "/" of it as integer as string)) of preceding text of first " " of following text of first "I " of it) of lines whose (it contains "Completed backup to") of files whose (name of it as lowercase contains "history.log.0") of folders "/Library/Logs/CrashPlan" as string) as date)

A: 1 day
2 Likes
3

Haha, now why didn’t I twig that (maxima being the plural of maximum)? Lovely, thank you!

4

Is this part of an analysis that you’d be able to share on BigFix.me?

5

Absolutely! Are you using Crashplan too? Let me finish it off and polish it up and I’ll share it there.

1 Like
6

Awesome, thanks! Yep, we’re using CrashPlan or at least investigating it.

1 Like
7

we’ve got crashplan here at IBM for our Macs

2 Likes
8

Oddly enough, we use IBM’s Tivoli Storage Manager (TSM) for most of our backups

1 Like