CA Service Management

I'm trying to search requests using the "Additional Search Arguments" option.  My arguments below work great, but I want to replace the last_mod_dt with a real date.  I feel like this can be done, but can't get the syntax right.

(act_log.analyst.last_name in ('dunn','berry') AND act_log.last_mod_dt >= 1527825600 AND act_log.last_mod_dt <= 1530417599)

Can I use something like this?

(PdmString (act_log.last_mod_dt) >= '2018-06-01')

Hi Laura,

Unfortunately I don't believe this is possible as noted the last_mod_date is stored in epoch format, which is not just date, but date/time.

Even if you added HH-MM-SS to the search argument it's still not able to convert that to epoch time.

For scoreboard queries it is possible to use time spans such as "TODAY" as noted below:

How can I use date/time criteria in scoreboard que - CA Knowledge 

I ran some tests using this with search arguments, but unfortunately still received a bad where clause.

Thanks,

Scott

laura.white 

Do you have any additional questions on this topic?

If not, please mark the answer provided byjohsc03 as correct so this thread can be closed.

Laura, I think it worth submitting an idea so CA Dev may consider adding some functionalities that end users don't have to search using epoch time...I don't think every end user knows what it is and how to convert. Thanks _Chi

Thank you Josh!