Missing Date in Date time format

[r3570]

Hi All,

I have a dataset with date column which is in character format as below:

2021-02-03T10:20:00

-----T08:45:00

-----T09:08:00

2020-12-21T08:28:00

My requirement is to fill the missing date with day 1 of the current year and convert the date column into numeric format.

Also,

I have date values in character format as below

2020-12-22T15:19:00

2021-01-05T15:29

I would like to add 00 to the second record so that first record and second record have same format.

Kindly help.

[LinusH · Accepted solution]

Fot the firrst scenartio I woiulr use compress to remove the dashes, and then concatenate with the date string of your choice.

If you store the result as a numrical datatime varible, you can chose a datetime format that will automatically display all values in the same format.