Specialized And Data Driven

  • Data Integration Specialist
    • Warehouse integrations
    • ERP service call integrations
  • AX 2012R2 BI Contractor
    • Business Intelligence
    • X++ Developer
    • Security
  • Microsoft Dynamics 365 For Operations
    • Data Entities
    • Application Deployment
    • X++ Application Patches
    • X++ Coding
    • Visual Studio integration with Team Foundation Services
  • Business Intelligence Systems

Every project I work on is an exercise in efficiency, scalability and integrity.

 

Recent Posts

Powershell – Script for Dates for file naming

This script produces the output:

20180606

20180605

For the date of 06/06/2018.

cls
$DaysBack =-1
$Yr = Get-Date -format yyyy
$Mt = Get-Date -format MM
$Dy = Get-Date -format dd
$TodayString = $Yr+$Mt+$Dy
$YD = Get-Date
$YD = $YD.AddDays($DaysBack)
$Lyd = ($YD.Year).ToString()
$Lmd = '0'+ ($YD.Month).ToString()
$Lmd = $Lmd.Substring($Lmd.Length-2)
$Ldy = '0'+ ($YD.Day).ToString()
$Ldy = $Ldy.Substring($Ldy.Length-2)
$YesterdayString = $Lyd+$Lmd+$Ldy
ECHO $TodayString
ECHO $YesterdayString

  1. Great Plains – Asset TSQL Case Statements Comments Off on Great Plains – Asset TSQL Case Statements
  2. DOCTYPE Case Statement for Great Plains Comments Off on DOCTYPE Case Statement for Great Plains
  3. DISTTYPE Case Statement for Great Plains Comments Off on DISTTYPE Case Statement for Great Plains
  4. SSIS Expression Convert From IntDate to String Comments Off on SSIS Expression Convert From IntDate to String
  5. Budget Form for people who need one Comments Off on Budget Form for people who need one
  6. TSQL – Replace URL Escape Characters Comments Off on TSQL – Replace URL Escape Characters
  7. Editing AX 2012 SSRS Report – PurchPurchaseOrder Comments Off on Editing AX 2012 SSRS Report – PurchPurchaseOrder
  8. Could not find [class].[method] in the method map. Will attempt to use X++ delagates. Comments Off on Could not find [class].[method] in the method map. Will attempt to use X++ delagates.