Calculated Field Using Date

A forum for Custom Reporting & SQL Queries in Deltek Vision.
ajborrelli
Posts: 2
Joined: Mon Feb 09, 2015 4:03 pm
Deltek Vision Version: 6.2
Number of Employees: 10000
Company Position: IT Business Consultant
Vision Modules: Project Control, Accounting, Billing, Time, Expense, Payroll, Multicurrency, Multilingual, Performance Management
Number of Offices: 0
Year Vision Installed: 1999

Calculated Field Using Date

Postby ajborrelli » Mon Feb 09, 2015 4:08 pm

I would like to show 2 columns on a report I have to run monthly - Period Year and Period Month. I assumed I could do this through a calculated field, but it is not working.
I created a calculated field called Period Month under Project > Project Earnings. I put in this formula: DATEADD(mm, - 1, GETDATE()), but I am getting several errors. I am trying to get 01 returned (today is 2/9/2015).

Is it even possible to do what I want with a calculated field?

meaglin
Posts: 195
Joined: Thu Nov 05, 2009 10:36 pm
Brief Company Description: Deltek Vision Consultant
Deltek Vision Version: 6.1
Number of Employees: 2
Company Position: Owner/Consultant
Vision Modules: ALL
Number of Offices: 0
Year Vision Installed: 2005
Vision User Group: Utah
Contact:

Re: Calculated Field Using Date

Postby meaglin » Sun Feb 22, 2015 1:36 pm

That is not a proper formula, are you wanting a date or a period? You may have to do an "if" statement in the Custom Calc
Mel Eaglin
meaglin@vrsllc.com
Visionary Reporting Solutions
San Diego, CA 92109
http://www.vrsllc.com/
http://www.deltekvisionconsultant.com/deltekvisionblog
Phone: (858) 245-8956
"Skype Name: mel.eaglin"

ajborrelli
Posts: 2
Joined: Mon Feb 09, 2015 4:03 pm
Deltek Vision Version: 6.2
Number of Employees: 10000
Company Position: IT Business Consultant
Vision Modules: Project Control, Accounting, Billing, Time, Expense, Payroll, Multicurrency, Multilingual, Performance Management
Number of Offices: 0
Year Vision Installed: 1999

Re: Calculated Field Using Date

Postby ajborrelli » Mon Feb 23, 2015 9:24 am

I want one calculated field that is the Month -1 and one calculated field that is the year except in January, I want it to be the Year -1.

meaglin
Posts: 195
Joined: Thu Nov 05, 2009 10:36 pm
Brief Company Description: Deltek Vision Consultant
Deltek Vision Version: 6.1
Number of Employees: 2
Company Position: Owner/Consultant
Vision Modules: ALL
Number of Offices: 0
Year Vision Installed: 2005
Vision User Group: Utah
Contact:

Re: Calculated Field Using Date

Postby meaglin » Mon Feb 23, 2015 10:15 pm

As I said, will take some more work and tweaking to the formula. Dates are tricky...
Mel Eaglin
meaglin@vrsllc.com
Visionary Reporting Solutions
San Diego, CA 92109
http://www.vrsllc.com/
http://www.deltekvisionconsultant.com/deltekvisionblog
Phone: (858) 245-8956
"Skype Name: mel.eaglin"


Return to “Custom Reporting & SQL Queries”

Who is online

Users browsing this forum: No registered users and 2 guests