Creating a file name with Monday following run date and formatted mmddyy

Question

Hi All-

I have been all over the forums and found bits and pieces, but an still struggling. I'm trying to use a formula tool to define a file name, which includes a date in mmddyy format, where the date is the monday following the run date. The input data is really irrelevant, so I'm not including anything.

Can't wait to see what you come up with.

Thanks!!

katherinetdavita · Answer

Hi! Thanks for this - I actually need it to be the Monday following the run date. So if I run it today, I need the date to reflect 1/27/2025 in the format "012725"

Qiu · Answer

@katherinetdavita 
I was not quite sure you want the the running date or the the Monday of the week of running date.
Anyway, we can use DateTime function to get both.

0123-katherinetdavita.yxmd