Date & Time Incrementing X minutes

[#1]

Hi guys,

I need to autogenerate ten rows, starting from 01/01/1900 07:00, incrementing each line ExtraMinutes. Something Like:

DateTime	ExtraMinutes
01-01-1900 07:00
01-01-1900 07:10	10
01-01-1900 07:30	30
01-01-1900 07:50	50
01-01-1900 09:00	120
02-01-1900 03:00	1200

How can I achieve that?

Thanks in advance,

Aldo.

load

Date(MakeDate(1900,1,1)+RowNo()-1,'DD/MM/YYYY hh:mm') as WorkDateSecuence

autogenerate 10;

[#2 · Accepted solution]

Guys, I did it the way below

Aldo.

load

//Date(myDate+ myHour/24 + myMinutes/24/60,'DD/MM/YYYY hh:mm')

, Date(MakeDate(1900,1,1)+ 07/24+ ((RowNo()-1)*120)/24/60,'DD/MM/YYYY hh:mm') as x2

autogenerate 10;