Date to integer?

[Scott]

HI everyone,

I am looking to convert a date to integer, how do I go about this? column below

1 2 3 4 5 6

Qtr-Year Mar-90  Jun-90 Sep-90 Dec-90 Mar-91

do I first need to change the date format to '031990' etc then change it to a str then interger?

I appreciate any help
Thanks

[heiner55]

Convert it into a datetime object:
See here: https://python-forum.io/Thread-help-with...-to-Python

Or convert into a time object:
See here: https://docs.python.org/3.7/library/time.html

[buran]

better if year is firs and then month, e.g. 9003, 9006, etc. this will allow to sort the integers in correct order