How to generate timestamps for the dataset?

[gemrose]

Hi,

I am working on a POC project. I need to add timestmap command to use predict algorithm. My dataset however has the below fields.

MonthYear

Year

Quarter

Month

Subscription ID

Subscription name

I was looking for a solution to randomly add timestamps for a period of one year. I have data from March2023 till May2023.

March 2023		Qtr 1	March	020b3b0c-5b0a-41a1-8cd7-90cbd63e06	SUB-PRD-EU-EDLCONTACTS
March 2023		Qtr 1	March	020b3b0c-5b0a-41a1-8cd7-90cbd63e06	SUB-PRD-EU-EDLCONTACTS

[ITWhisperer]

| eval _time=strptime("2023-03-01","%F")+(random()%(strptime("2023-06-01","%F")-strptime("2023-03-01","%F")))