18
I want to add a variable into the number of days to subtract a date from.
Current expression:
Share
ReportformatDateTime(addDays(utcNow(),-1), 'yyyy-MM-dd')
To-Be expression: (error: The expression is invalid)
formatDateTime(addDays(utcNow(),-variables('XDays')), 'yyyy-MM-dd')
Instead of a fixed "-1", I want to replace this with a variable, which I have the String and Integer format.
May I know what is the correct expression to implement this? Thank you
Hi @JeremyTan
Pls try the below expression:
All responses (
Answers (
formatDateTime(addDays(utcNow(),mul(variables('XDays'),-1)), 'yyyy-MM-dd')
If this helps & solves your problem, please remember to give a 👍 and accept my solution as it will help others in the future.
