Add/Subtract Date” Function in rule returns date value.

  • 25 November 2019
  • 3 replies

Userlevel 5
Badge +3

Hi Team.

Working with one of the customer and found an issue with “Date Formula” field in Rules. Especially with the “Add/Subtract Date” Function.


Issue was, once we add or subtract any days to the “DateTime” data type field using  the “Add/Subtract Date Function”, we are getting an Output as “Date” format, instead datatime. 

It was causing an issue when we try to use that Formula field in the Action Criteria Part.


But when we are the Execution History tab showing “No details to display”.





Best answer by suryanarayana 25 November 2019, 12:40

View original

3 replies

Userlevel 5
Badge +2

Hey Phani,

I have faced similar issue and my turn around was:

Use Date function in Task1 and convert it into Date field.

In Task 2 use this Date Field and do your transformation.

Thank You

Userlevel 3

@phani_kumar @suryanarayana  This issue is fixed now. 

On adding or subtracting any days to the “DateTime” data type field using the “Add/Subtract Date Function”,  the output field also will be “DateTime” now. 

Userlevel 5
Badge +3

Thanks @tulasi_andukuri