Date generating problem

[#1]

Hi bro,

I have a downtime and uptime dates now i want generate dates between them in a date format. If field1 is less than filed2 i need to display all the dates in between them. I'm attaching the attachment of input data and output. Please help me......

[sunny_talwar]

I think you need IntervalMatch functionality. Look here: IntervalMatch

HTH

Best,

Sunny

[jagan]

Hi,

You can using while like below

LOAD

ID,

Field1,

Field2,

TimeStamp(Floor(Field1 + IterNo() -1)) AS NewFieldName

FROM DataSource

WHILE (Field1 + IterNo() - 1) <= Field2;

Hope this helps you.

Regards,

Jagan.

[#4]

HI sunny/Jagan

Thanks ur replies both queries are working fine......

[sunny_talwar]

Awesome

Glad we were able to help. Please close the thread by marking Correct and Helpful answers (if any)

Best,

Sunny