How to get upcoming friday date

[vb1612]

I have a date field in my feed as "2/15/2019" , want to compare this with upcoming friday date value in search.
please help how to do this

[renjith_nair · Accepted solution]

@vb1612,

To get next friday, you can use

|eval next_friday=relative_time(now(),"+1w@w5")

To get the difference ,

"your base search"
|eval give_date_in_epoch=strptime("2/15/2019","%m/%d/%Y")
|eval next_friday=relative_time(now(),"+1w@w5")
|eval diff=next_friday-give_date_in_epoch

Feel free to change the variable names.