— The Forums are now read-only —
— All new activity now takes place here: —
Hi Everyone,
During an import scenario, has anyone attempted to calculate the Post Period based on today's system date?
Hi Kermit,
I haven't, but have you tried the Today() formula?
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?
=Format('{0:MMyyyy}',Today())
@timrodman I just tried this on an import I was creating and it said
This was on a 2020r2 system. Any ideas?
Thanks in advance for your help!
Hi @jswartz,
Sorry, I haven't tried this in a few years.
I recommend posting this in the new official Acumatica Community Forums:
https://community.acumatica.com
For the foreseeable future, the Forums here will focus on the Reporting Tools in Acumatica (Dashboards, Generic Inquiries, Report Designer, ARM Financial Report Writer, Velixo, Excel, Power BI, etc.) and also discussions that are too “transparent” to be allowed in the new official Acumatica Community Forums. For more info about how AUGForums.com compares to the new official Acumatica Community Forums, checkout this post:
https://www.augforums.com/augforums-com-vs-the-official-acumatica-community
Yes! That's exactly what I needed. Thank you!
By using this website, you agree to our Terms of Use (click here)
