Month to Date Format

ansn
Occasional Contributor

Month to Date Format

Spoiler
I have monthly date as Jul 21, I want that to converted in last date of the month in 07/31/2021 format, is there a specific formula for the same?
1 ACCEPTED SOLUTION

Accepted Solutions
Misbah
Moderator

@ansn 

 

Write END(Date) as formula. If there is a time as a dimension then just END() would do

 

Misbah

View solution in original post

3 REPLIES 3
Misbah
Moderator

@ansn 

 

Write END(Date) as formula. If there is a time as a dimension then just END() would do

 

Misbah

ansn
Occasional Contributor

Thanks for the help.
tejaswini
Contributor

@ansn 

 

You can use End() function to get end date of the month

 

Reffer -  https://help.anaplan.com/3d41a077-b391-45ca-a6e2-0c6dfaaeb85f-END

 

Thanks