I am trying to create a starting point to calc the current YTD totals verses the previous YTD totals. I have tried using the 'Today', 'Curdate' and 'Now' function, but cannot strip off the year or Month from these functions. When I use [year(Curdate())] I get the following: "The function...
I tried using the results of thread401-727756 with no good results. I have a text file, example:
001First & Last Name 1G,R,A
Where the 1st 3 pos are the salesman # the next 29 is the name, the next 1 is the saleman type and the last 7 are the Divisions the salesman is associated...
How do I create a network drive, move data to it, close the drive and reuse the same drive for a new network location? I have 15 branch locations that I need to send data to each server within the macro.
I have a set of Impromptu reports that produces a salesman list using three prompts each. I am new to Cognos macros and need a way that a user could maintain a list of salesman numbers, approx 50, slsm type and possible divisions. Using this list of prompts, the process generates the customers...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.