Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Free Trial

Alteryx Designer Desktop Discussions

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

Date

Niveditha
5 - Atom
‎01-24-2023 06:40 AM

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 

Labels:
Reply
4 REPLIES 4
ShankerV
17 - Castor
‎01-24-2023 06:44 AM

Hi @Niveditha 

 

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

Reply
0 Likes
Felipe_Ribeir0
16 - Nebula
‎01-24-2023 06:45 AM

Hi @Niveditha 

 

You can use this formula

 

datetimetrim(datetimetoday(), 'lastofmonth')

 

Felipe_Ribeir0_0-1674571519494.png

 

Reply
FinnCharlton
13 - Pulsar
‎01-24-2023 06:45 AM

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

FinnCharlton_0-1674571860536.png

 

 

End of Month.yxmd
Reply
ShankerV
17 - Castor
‎01-24-2023 06:56 AM

Hi @Niveditha 

 

Please find the expected output.

 

ShankerV_0-1674572188097.png

 

Date.yxmd
Reply
0 Likes
register for inspire
designer new user guide
Labels
Top Solution Authors
View All