By using this website, you agree to our Terms of Use (click here)
Notifications
Clear all
July 22, 2017 1:54 am
Hi Everyone,
During an import scenario, has anyone attempted to calculate the Post Period based on today's system date?
5 Replies
July 22, 2017 1:54 am
Hi Kermit,
I haven't, but have you tried the Today() formula?
July 22, 2017 1:55 am
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.
July 22, 2017 1:56 am
Ah, I see what you mean. What about this formula?
=Format('{0:MMyyyy}',Today())
January 6, 2021 12:18 pm
@timrodman I just tried this on an import I was creating and it said
"An error has occurred while the Format(Const({0:MMyyyy}), Today()) function was being executed: 'Input string was not in a correct format."
This was on a 2020r2 system. Any ideas?
Thanks in advance for your help!
July 22, 2017 1:56 am
Yes! That's exactly what I needed. Thank you!
Online Members
