Hello, I am a novice in stata, but I have spent several hours trying to solve this issue without any luck.

I have downloaded several monthly datasets from the Bloomberg terminal to excel files. When choosing monthly data, Bloomberg always gives you the last date in each month (31/01/1985, 28/02/1985, 29/03/1985, etc...). One of the variables is attached, the Baltic Dry Index

When importing the excel file into STATA with the time variable named "Date", I run the following code:
Code:
. tsset Date

Time variable: Date, 31jan1985 to 31jan2022, but with gaps
        Delta: 1 day
Stata automatically believes the data is daily. When I try to tell stata that the data is monthly, it gives the following warning, with a format I cannot interpret:
Code:
. tsset Date, monthly
warning: Variable Date had been formatted %td (a daily period), and you asked
         for a monthly period. Are you sure that is what you want? Format has
         been changed. Date is now formatted %tm.

Time variable: Date, 2723m7 to 3849m9, but with gaps
        Delta: 1 month
Is it it displaying month 7 in the year 2723 to month 9 in the year 3849? How do I format it to display 1985m1 to 2022m1?