Add 2 weeks to a Separation date

Hi @shannon.mejia .

Hope you’re doing great.

Working with dates requires you to use ISO format.

And, in the testing area, dates need also to be single quoted.

Please find below some screenshots for further reference:

Hope this helps.

Regards,

Elvis, that was very helpful!  

It seems my first expression is the issue.  I basically have this as the “Get Separation Date”, but i dont really have an expression.  Any help here?  I need to get this date from the service item form so i can then do the next expression to add the 14 days to it.  This is my expression to get the seperation date to then add the 14 days to it

shannon.mejia wrote:

Elvis, that was very helpful!  

 

It seems my first expression is the issue.  I basically have this as the “Get Separation Date”, but i dont really have an expression.  Any help here?  I need to get this date from the service item form so i can then do the next expression to add the 14 days to it.  This is my expression to get the seperation date to then add the 14 days to it

 

 

Hi, 

Could you post the expression as text as well, easier to to read it :) Use the Add code box ( you can find it under the 3 dots above the text box in the forum) 

When you test you may need to use ISO format as well. 

shannon.mejia wrote:

Elvis, that was very helpful!  

 

It seems my first expression is the issue.  I basically have this as the “Get Separation Date”, but i dont really have an expression.  Any help here?  I need to get this date from the service item form so i can then do the next expression to add the 14 days to it.  This is my expression to get the seperation date to then add the 14 days to it

 

 

Hi. I’m glad I could help.

If I understood correctly your goal, you don’t actually need to split and convert that ISO to work with it.

You may operate with the ISO field and then use only the date.

Check this out:

And if we add the dateValue formula, you’ll get only the date:

But, if going to the root, you can actually not work with ISO format and work only with date.

When choosing your field, I’m guessing your choosing the dropdown arrow and using ISO:

But it is not mandatory to do it that way; you may simply get the field in standard value:

The no-ISO field would provide only date:

So, your result would be in date.

Hope this helps.

Regards,