I can't seem to find a function that returns the day of the month for a given value. I would like it so I can go that amount -1 to get the last day possible for the previous month.
If there is a better way, I am open to ideas. Thanks!
where do you need it, in forms or workflow?
in either case, following should help you Date and Time Format Strings - Quick Reference Guide
Retrieving data ...