Question
Cognizant Technology Solutions India PVT Ltd
IN
Last activity: 26 Jan 2021 2:18 EST
Subtract datetime value to 5 mins prior
I need to subtract user given datetime value to 5 mins difference (prior) to trigger mail in SLA.Which function can be used to get the difference for this. Kindly help.
EX: User Input date time value : 1/28/2020 11:00 AM
required prior value must be :1/28/2020 10:55 AM
Aaseya IT Services Pvt LTD
SA
Hi
On the change of the user input date time value, call a DT and call the datetimediff function and subtract 5 mins time from the input date time. Please try this.
Cognizant Technology Solutions India PVT Ltd
IN
@PrakashDeep Hi Thankyou for the Response. But the datetimediff function can be used when two different time inputs (Begin time and End Time) are present. In my scenario I have only one user input datetimevalue and that needs to be changed by substracting 5 mins. Also please help how this subtraction can be achieved. Thankyou
Aaseya IT Services Pvt LTD
SA
Hi,
Please try with the below function. I have parameterized the input parameters but you can do so only for minutes and pass other as '0' by default.
