Is this the last day of the calendar month? How to find the last day of the month

[sathyar]

I have the dataset where date ranges from 2021 to 2025 .From this i have separate column for date field in the format of yyyy-mm-dd  from this how to find the last day of the each month .If that date is the last day of the month then written yes else no .

I need help on this .

[CoG]

IF DateTimeMonth(DateTimeAdd([Date],1,'day')) != DateTimeMonth([Date]) THEN "yes" ELSE "no" ENDIF

Are you looking for something like this?

[Qiu]

@sathyar 
There is a build in Function in DateTimeTrim for the last of Month.

@CoG 
Very smart thinking. 😁