Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.

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

sathyar
8 - Asteroid

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 .

2 REPLIES 2
AndrewDMerrill
13 - Pulsar
IF DateTimeMonth(DateTimeAdd([Date],1,'day')) != DateTimeMonth([Date]) THEN "yes" ELSE "no" ENDIF

Are you looking for something like this?

Qiu
21 - Polaris
21 - Polaris

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

@AndrewDMerrill 
Very smart thinking. 😁

1108-sathyar.PNG

Labels