Import Scenario Post Period based on Today's date
During an import scenario, has anyone attempted to calculate the Post Period based on today's system date?
I started to, but formatting around the Today() function is the issue.
First, month, then year. But if month is less that 10, need to add the 0 plus right, 2 so it stays a 2 digit month.
Just thought I'd check. Thanks.
Ah, I see what you mean. What about this formula?
Yes! That's exactly what I needed. Thank you!