Generate data with datetime between two precised hours

#1

Would it be possible to have datetime increment between two precised hours :

Here is what I have for my datetime :

(date(‘28/04/2017’) + 26400 + minutes(id)).strftime(’%d-%m-%Y %H:%M:%S’)

It starts at 07:27:00 and increments every minute, but I want it to stop at 19:00:00 and restart at 07:27:00 and so on.

#2

Yes, you can use a sequence with the “restart at” option to generate the number of minutes. Then use a formula to add that to a fixed date.

#3

Thank you for the idea