Hi Community Champs,
I was able to get the date difference with this formulae
int(first(split(dateDifference(formatDateTime(utcNow(), 'yyyy-MM-dd'),
formatDateTime(parseDateTime(items('Foreach')?['Certifcation_x0020_Date']), 'yyyy-MM-dd')),'.')))
for the below Certification Date input
Now date format is changed to below
Error message:
The error occurred in the 'Condition__1' operation. The error message indicates that the value '27/12/2025' provided for the date time string is not valid. To fix this error, you should ensure that the date time string is in the ISO 8601 format, which is 'yyyy-MM-dd'. In this case, you should change the date value to '2025-12-27'.
I am using Google sheet, how should i proceed ?
Riti
