DateTimeAdd Multiple Days

[timioluwatimi]

[DateColumn2] = DateTimeAdd("2021-01-30", 10, "days")   will return   data from  10 days after 30th of January which is 9th February. How do I get data from the first 10 days  after "2021-01-30" instead?  i.e. every single day from 31st January till 9th February.  

[Luke_C]

@Gaurav_1604 

Assuming No. of Days is numeric the below should work:

datetimeadd([Date],[No. of Days],'days') 

[Gaurav_1604]

Thanks Luke_C..

[No. of Days] is a numeric field. Actually I had term field as 1D, 3M, 6M , 1Y, 3Y etc. which I converted to days and am trying to use this field in 'GenerateRows' tool but am getting error message 'Argument 2 of DATETIMEADD is not a number'.