Date

[Niveditha]

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 

[ShankerV]

Hi @Niveditha 

You can use the Formula tool, to convert the date to end of the month.

[Felipe_Ribeir0]

Hi @Niveditha 

You can use this formula

datetimetrim(datetimetoday(), 'lastofmonth')

[FinnCharlton]

Hi @Niveditha, here is one way to do this:

[ShankerV]

Hi @Niveditha 

Please find the expected output.