Howdy, Stranger!
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.5K Microsoft Dynamics NAV
- 18.5K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 115 Navision DOS
- 854 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 615 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 264 Dynamics CRM
- 109 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 992 SQL General
- 385 SQL Performance
- 33 SQL Tips & Tricks
- 34 Design Patterns (General & Best Practices)
- Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.7K General
- 1.1K General Chat
- 1.6K Website
- 79 Testing
- 1.2K Download section
- 23 How Tos section
- 259 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions
Options
How do I use the "Define Calculated Fields" in Nav-Classic
CowsRUS
Member Posts: 5
Hello all noob here, 
I am working with Navision Classic 2009 R2 in the object designer, Form, Style Sheet Card. I am building forms and I am trying to figure out how to use the "Define Calculate Fields". I've tried looking online but there seems to be nothing much on using "Define Calculate Fields" on 2009 R2 Classic. I'm not sure on how to create a formula. I am trying to create a Blanket Period date that is exactly 1 year from the ETD Port of Loading date. So if the ETD Port of Loading Date is 3/10/15 the next date should be 3/10/16.
(ie)
Blanket Period:
From date: 3/10/15 To date: __________
I can pull up the ETD Port of Loading date but can not seem to formulate to get it to pull a date 1 year from the original date :-k . I don't know how to create a formula. From some googling it seems that I need to put an = sign first but then what after then? Please help!
I am working with Navision Classic 2009 R2 in the object designer, Form, Style Sheet Card. I am building forms and I am trying to figure out how to use the "Define Calculate Fields". I've tried looking online but there seems to be nothing much on using "Define Calculate Fields" on 2009 R2 Classic. I'm not sure on how to create a formula. I am trying to create a Blanket Period date that is exactly 1 year from the ETD Port of Loading date. So if the ETD Port of Loading Date is 3/10/15 the next date should be 3/10/16.
(ie)
Blanket Period:
From date: 3/10/15 To date: __________
I can pull up the ETD Port of Loading date but can not seem to formulate to get it to pull a date 1 year from the original date :-k . I don't know how to create a formula. From some googling it seems that I need to put an = sign first but then what after then? Please help!
0
Comments
Syntax (Search for it in the Dev Help) Example:
Date := 100315D; NewDate := CALCDATE('<+1Y>',Date); MESSAGE(FORMAT(NewDate));I thought you were talking about actual code.
Sorry can't help you here, seems you are using some kind of special tool or a different version as i don't have this object.