TOPIC: using Javascript to add yesterday's date to name

using Javascript to add yesterday's date to name 07 Aug 2013 14:29 #1429

  • flowersrj
  • flowersrj's Avatar
  • Offline
Hi,

Can anyone tell me what is wrong with this RRD? It won't open thru the GUI so I assume it does not run. I am trying to concatenate yesterday's date to the filename since its output will represent yesterday's data.

Thanks, Rich

;WORKSPACE_MODE=FALSE
SaveReport[CW-BillingProductivity-Daily-Export]=F:\LogicityReports\CW-HCN\Reports\BillingProductivity.rpt?DiscardSavedData=True&dbserver=&dbdb=&dbuser=myUserid&dbpass=myPassword&saveas=\\1loci-acct\ds\HC\MSO\Billing\Well\Billing Productivity\%CURRENT_YEAR%\BillingProductivity_%DateSerial(Datepart("yyyy",date()-1),DatePart("m",date()-1),DatePart("d"),date()-1))%.xlsx&export=Microsoft Excel Workbook Data-Only (XLSX)&pdfPassword=&SaveSupressIfNoRecords=False&logfile=F:\LogicityReports\CW-HCN\Logs\BillingProductivity.csv¶m[AccountingPeriod]=2013_06¶m[FromDate]=2013-08-06¶m[ThruDate]=2013-08-07&
Last Edit: 07 Aug 2013 14:30 by flowersrj.
The administrator has disabled public write access.

using Javascript to add yesterday's date to name 31 Oct 2013 14:22 #1465

  • jpalmer1717
  • jpalmer1717's Avatar
  • Offline
did you ever figure this out? support won't answer me...
The administrator has disabled public write access.

using Javascript to add yesterday's date to name 31 Oct 2013 15:30 #1467

  • mholbrook
  • mholbrook's Avatar
  • Offline
Hi Guys,

In order to manipulate the date inside of Logicity you will need to use vb script. An example of this if you were looking to display 3 days prior would be %{DateAdd("d", -3, DATE )}% . You can add or subtract days by modifying the formula.

Thanks!
The administrator has disabled public write access.

using Javascript to add yesterday's date to name 18 Nov 2013 20:45 #1474

  • flowersrj
  • flowersrj's Avatar
  • Offline
Would I use it like this in a RRD?

... ¶m[StartDate]=%{DateAdd("d", -3, DATE ) }%&

Thanks, Rich
The administrator has disabled public write access.

using Javascript to add yesterday's date to name 18 Nov 2013 20:48 #1476

  • bellis
  • bellis's Avatar
  • Offline
Yeah, it looks like the forum garbled it a bit, but that should do what you are looking to accomplish. Note, that you'll need Logicity Pro for variable replacement to work.

Thanks!
Brian
The administrator has disabled public write access.

Logicity Logo White 300

526 S Main St., Suite 805, Akron, OH 44311 USA
855.758.0100
sales@logicitysuite.com