I want to create automatic obsolecance reports in Splunk. I grab the info from a database. There is a collum that has the obsolecance date in it.
Now I want to compare that date with the current date when the job is run and depending on how much time is left between them they get an obsostatus (12 moths or less-> obsosatus 1 and so on). The dates look like this: 2012-11-30 00:00:00.0
Does someone has suggestions on how to do this?
thx in advance