FormattedDateToEpoch

Converts a custom-formatted timestamp to UNIX epoch time. Use it to convert custom time stamps to a XSOAR date field. If you pass formatter argument, we will use it to transform. If not, we will use dateparser.parse for transforming. For more info, see: https://docs.python.org/3.7/library/datetime.html#strftime-and-strptime-behavior

Type

python

Pack

FiltersAndTransformers

Source

from datetime import UTC, datetime

import dateparser
import demistomock as demisto


def date_to_epoch(date: str, formatter: str | None = None) -> int:
    epoch = datetime(1970, 1, 1, tzinfo=UTC)
    date_obj = (
        datetime.strptime(date, formatter)
        if formatter
        else dateparser.parse(date, settings={"RELATIVE_BASE": datetime(1900, 1, 1)})
    )
    assert date_obj is not None, f"could not parse {date}"
    return int(date_obj.strftime("%s") if date_obj.tzinfo is None else (date_obj - epoch).total_seconds())


def main():
    args = demisto.args()
    date_value = args["value"]
    formatter = args.get("formatter")
    demisto.results(date_to_epoch(date_value, formatter))


# python2 uses __builtin__ python3 uses builtins
if __name__ == "__builtin__" or __name__ == "builtins":
    main()

README