how to lag timetable to the nearest day

i have this timetable how can i lag this timetable to the nearest day(the present day is '01-Mar-2018' and the nearest day is '06-Mar-2018')

[Kevin Chng]

What do you mean lag here? All the date replaced by the next nearest date?

Answer 1

[Peter Perkins]

"Lag" means different things to different people.

You might mean, "round the row times to the nearest whole day." Just apply dateshift to the row times.

You might mean, "interpolate the data at whole days." Use retime.

"Lag" usually means, "shift the data down one observation, keeping the same row times." The lag function does that, but I don't think that's what you want.