Notifications
Announcements
No record found.
We use T for today's date but I have tried using T-1 and the date comes back as 1/5/10 instead of yesterday's date. Is there a shortcut for yesterday's date in NAV 5.1?
*This post is locked for comments
With coding on a button = yes but with having only to type in 4 numbers 1114 to get to 11/14/2010
I will assume the code change is not very useful.
you can get to a day with 2digits too:
mo=monday
tu=tuesday
we=wednesday
th=thursday
fr=friday
etc..
so if today is thursday and I don't want to type "1117" I could type "we"
Good afternoon.
As the previous person mentioned, you have the options to set your day
tu=tuesday etc...
The reason why you were getting 01/05/2010 when doing t-1 is because it is going based on the calendar year of Jan-Dec where there are 52 weeks. By doing the dash 1, you are stating take the tuesday in week 1 within the year. If you did t-2 then it would do tuesday within week 2 that being 01/12/2010.
This is how base NAV is coded and if you are looking to do the yesterday, you would need to say t-48 to get 11/30/2010(going based on today's date of 12/01/2010). Beyond this, it would require some type of modification to do any type of formula like -1y, 1w etc...type of formulas.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
HoangNam 7
