[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.
Solved! Go to Solution.
Assuming No. of Days is numeric the below should work:
datetimeadd([Date],[No. of Days],'days')
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'.