core.noscript.text
How do I ensure no matter what date is present, the resultant date considered for calculation will always be the end of the month for that date
Hi @Niveditha
You can use the Formula tool, to convert the date to end of the month.
You can use this formula
datetimetrim(datetimetoday(), 'lastofmonth')
Hi @Niveditha, here is one way to do this:
Please find the expected output.
