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
-
I am not sure if i understand you correctly but for Date Calculation you can use the CALCDATE Function
Syntax (Search for it in the Dev Help)NewDate := CALCDATE(DateExpression [, Date])
Example:Date := 100315D; NewDate := CALCDATE('<+1Y>',Date); MESSAGE(FORMAT(NewDate));
0 -
Thank you for the response. I tried what you suggested and it didn't seem to work. Am I entering it wrong? Please let me know. I am trying to create a Define Calculated Field from the Object Designer > Form > Style Sheet. There is already a Style sheet code that lets me pull out the beginning date that I want. I want the ending date to be exactly one year from that beginning date. Does that make sense? :-k
0 -
-
Oh, big misunderstanding here :roll:
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.0 -
Thank you for trying to help0
Categories
- All Categories
- 73 General
- 73 Announcements
- 66.6K Microsoft Dynamics NAV
- 18.7K NAV Three Tier
- 38.4K NAV/Navision Classic Client
- 3.6K Navision Attain
- 2.4K Navision Financials
- 116 Navision DOS
- 851 Navision e-Commerce
- 1K NAV Tips & Tricks
- 772 NAV Dutch speaking only
- 617 NAV Courses, Exams & Certification
- 2K Microsoft Dynamics-Other
- 1.5K Dynamics AX
- 320 Dynamics CRM
- 111 Dynamics GP
- 10 Dynamics SL
- 1.5K Other
- 990 SQL General
- 383 SQL Performance
- 34 SQL Tips & Tricks
- 35 Design Patterns (General & Best Practices)
- 1 Architectural Patterns
- 10 Design Patterns
- 5 Implementation Patterns
- 53 3rd Party Products, Services & Events
- 1.6K General
- 1.1K General Chat
- 1.6K Website
- 83 Testing
- 1.2K Download section
- 23 How Tos section
- 252 Feedback
- 12 NAV TechDays 2013 Sessions
- 13 NAV TechDays 2012 Sessions