Forum Discussion

amardeep2021's avatar
amardeep2021
New Contributor III
4 years ago

Issue while adding days to date field in mapper

Hi, I have a scenario where I am trying to increment a date field by 7 days in loop till it reaches another date value. I see data type as date for the field I am working, still while using plusDay...
amardeep2021's avatar
amardeep2021
New Contributor III
4 years ago

Thanks Bojan. I am able to use the expression suggested to add 7 days to date value. But it comes up with timestamp as well which I should not have. To remove timestamp I tried slice and substr fucntions both not working because of data type. Do you know how to remove timestamp from this? PFA of screenshot.

Also I want to achieve something like below.

If A <B
A = A + 7 days

Endif

Any tip for the above 2 would be helpful.

Regards,
Amar.