Issue while adding days to date field in mapper

Question

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 plusDays(7) function I am getting error. I couldn’t date.parse() as it’s already a date field. I can’t convert to string as I need to add days to the same field in loop. Does anyone know how to overcome this issue? Please advise.
PFA of screenshot from mapper snap.
Regards,
Amar.

bojanvelevski · Answer

Hey @amardeep2021,
Try parsing a stringified version of the date, like this:
Date.parse($weekof.toString()).plusDays(7)

amardeep2021 · Answer

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 &lt;B
A  = A + 7 days

Endif
Any tip for the above 2 would be helpful.
Regards,
Amar.

bojanvelevski · Answer

If you’re comparing this field with another, than parse the other field as well, do the comparison and use the .toLocaleDateString() function after, on both fields. That will help you get the date parts only.
Regards,
Bojan

amardeep2021 · Answer

Thanks Bojan. This works to trim timestamp.
Do you know how to increment the same date in loop till it reaches a specific date field value? Please let me know if you have any tips.
Regards,
Amar.

bojanvelevski · Answer

May I ask why do you need the loop when you already know the desired date? If you need all of the dates between two dates with step = 7 ( Ex.: 2022.01.01,…08,…15,…22,2021.01.29), than you can achieve this with the following expression:

sl.range(0,(($endDate-$startDate)/86400000)+1).filter(x=&gt;x%7==0).map(y=&gt;$startDate.plusDays(y))

Here is a sample pipeline as well:
Date Range Step 7_2022_01_20.slp (3.8 KB)
I hope you’ll find this helpful.

Forum Discussion

Issue while adding days to date field in mapper

Recent Discussions

trace API and proxy calls

Pagination Logic Fails After Migrating from REST GET to HTTP Client Snap

Pipeline Execute Pool size

Concat values of a field based on value of another field

JWT Configuration for SnapLogic Public API