Use between with 2 dates

[fernando-cg]

Hi im triyin to use between function to search cases between 2 dates and i don't revice any alert

now = datetime.datetime.now() - datetime.timedelta()
now = int(round(now.timestamp()))
before = datetime.datetime.now() - datetime.timedelta(minutes=10)
before = int(round(before.timestamp()))

print(datetime.datetime.fromtimestamp(now))

print(datetime.datetime.fromtimestamp(before))
query = And(Between('date', before,now))

response = api.find_alerts(query=query)
print(response.text)

I Have cases at the time i'm searching

[Kamforka]

@fernando-cg TheHive is handling timestamps in millisecond precision, Python is handling them as floats and the integer part is with second precision, so you should multiply by 1000:

ow = datetime.datetime.now() - datetime.timedelta()
now = int(round(now.timestamp())) * 1000
before = datetime.datetime.now() - datetime.timedelta(minutes=10)
before = int(round(before.timestamp())) * 1000

Something like the above should help