Set date field to current date + 10 days

Community Discussions How Do I
#1

I need to set a date field to the current date + 10 days. I have a date formula field that does this, however, I need to then take that formula and use it to set a regular date field so my users can change it if they need to. I’m thinking I need to use a pipe, but I really don’t understand how to use the syntax of the pipe functionality, and can’t find and documentation/training on this.

Thanks!
Marc

#2

Hi Marc-

Can you describe your project that would need to have a two-way flow of date changes? Is there a design restriction/need that would prevent the end user from changing the initial date field to automatically change the 10 day date formula?

~Adam

#3

The field is an expected return date which in most defaults to today+10. I have workflow that starts a process to start contacting customers on this due date. Sometimes there are shipping or other delays, so my user would like to change the date when this happens.

Basically, I need a way to assign a date to a standard date field.

Thanks!

#4

This could be done with some javascript. @Chem may be able to assist whereby the JS pulls from a field value plus 10 days and targets the field that would show the date+10.

#5

If the user changes the date, do you also want to add +10 days to it? The Date Utilities pipe has an API call to add days. You could use this and run it on record create/edit or both. Would that work?

I can show you how to set it up if you’d like.

#6

No. It should only be set when Created to the today+10. If they change it, they are on their own.
I think the pipe would work on the Create, but not sure how to set it up properly.

Thanks @tim.young

#7

@mdykstra

Hope this helps, let me know if you have any questions.

4 Likes
#8

This works perfectly. Thank you for your help @tim.young

1 Like
#9

You’re very welcome!

#10

How to set an email reminder before 2 days from due date? :thinking:

#11

@Black

You might try this criteria:

Notify Date is during the next 3 days
AND
Notify Date is after the next 2 days

#12

I agree with @mdykstra, if you are using the due date field as the trigger field for the notifications.

Adam

#13

Hey @tim.young any reason why this does not work. Date Utilities Pipe, Add Years. On create or edit.

TB date pipe set up
TB date pipe set up1304×720 51.3 KB

TB date pipe response
TB date pipe response1834×384 31.1 KB

thanks

#14

What value do you get as a response if you save the response to a text field?

Are there any rules that could be overwriting this value?

#15

Hi @tim.young

I did try it as a text value and i get the following based on a date format of dd/mm/yyyy - 0101/0101/42424242.

i changed the fomat to d/m/y and get 01/01/42

I do plan on performing another function on this field once i have the end date, so i guess i need it to be a date field.

This is a new field and has no rules applied to it other than setting the pipe response.

#16

If youre saving it back to a date field, it must be formatted in SQL date format.

Set the format to the following “Y-m-d”:

image
image1005×335 21.6 KB

#17

Thank you @moe that has worked and sending the value to the date field.

for future self service, could you point me to where i would have found this please.