Need all the timestamp between two dates.

Himanshu_Pant

I have a dataset which consist of timestamp. The timestamp are in a gap of 15 mins. If I have two dates stored into macros ( e.g. first_date, last_date), how can I fetch all the timestamp between two macros? Example:

2020-08-15T02:30:00.000Z

2020-08-15T02:45:00.000Z

2020-08-15T03:00:00.000Z

2020-08-15T03:15:00.000Z

2020-08-15T03:30:00.000Z

2020-08-15T03:45:00.000Z

2020-08-15T04:00:00.000Z

2020-08-15T04:15:00.000Z

lets say first macro i.e. first_date = 2020-08-15T02:30:00.000Z and second macro i.e. last_date = 2020-08-15T03:30:00.000Z. So with these two macro I want  5 timestamp as an output starting from 2020-08-15T02:30:00.000Z  and ending with 2020-08-15T03:30:00.000Z.

YYH

Hi @Himanshu_Pant, I did not understand "loop Attributes" in your process and replaced it with loop examples that create new timestamps with 15 min interval. See attached.

create new timestamps 15 min interval.rmp