monthsend is returning 70 years gap

[meme]

Please can you help.

Simple use of monthsend(3,[snapshot_date],-1,1)

example the snapshot date is 3/31/2023 it returned 5/1/1953.

not sure where is the 1953 coming from.

[tresesco]

Not sure, may be something to do with date format or so... Could you share a screen shot?

[Chanty4u · Accepted solution]

You can try this may be

MonthEnd(Date#('31/03/2023', 'DD/MM/YYYY'), -1)

[meme]

i think the dates are not on the same format so this helped. Thank you!