Month to Date Format

ansn

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?

Misbah

@ansn 

 

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

 

Misbah

tejaswini

@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

 

ansn

Thanks for the help.