Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. jessiejane

    Type Mismatch Error: CDate

    The format is in mm/dd/yyy. Not sure of how to get rid of the error.
  2. jessiejane

    Type Mismatch Error: CDate

    I am getting an error: Type mismatch CDate I have a text file and when the records in the text files complete 60 days then it writes to a file else puts in a seperate array. I get type mismatch error at CDate. I am not knowing where its going wrong. Any help is appreciated. The text file in...
  3. jessiejane

    Deleting the record from an Array String

    I have a text file in the format of "Name-Date" Sample of the text file: John-02/03/2010 Mary-05/20/2010 When the date meets the 60 day counter then the record should be deleted from the text file and any spaces in the text file should be removed. (I have converted the text file from array...
  4. jessiejane

    VBS script to delete files which are older than 30 days

    Try this code to delete files from a folder: Private Sub DeleteFiles(ByVal DirectoryPath As String) Dim files As String() = IO.Directory.GetFiles(DirectoryPath & "folder") - which folder you want to delete For Each CurrentFile As String In files Dim FileInfoDate...
  5. jessiejane

    Getting Date from a line string

    The string is in the text file ---------------------------- John-03/12/2010 Mary-05/01/2010 ---------------------------- I have used this code: Do Until objPurge.AtEndOfStream Redim Preserve arrPurge(intPurgeCounter) arrPurge(intPurgeCounter) = objPurgeFile.ReadLine Dim intx intx =...
  6. jessiejane

    Getting Date from a line string

    Doesn't work any ideas please.
  7. jessiejane

    Getting Date from a line string

    I have a string "John-2/3/2010". How would I get just the date from the string. Given: John-2/3/2010 Output: 2/3/2010
  8. jessiejane

    Appending data into the textfile in a new line

    It worked but I got another issue when I replace the writeline. When the purge file is empty, it adds all the records in the Temp file at that point it inserts an blank line on the purge file. Any help is greatly appreciated. ________________________________ Mary-02/12/2010 John-02/03/2010...
  9. jessiejane

    Appending data into the textfile in a new line

    Hi, I have a temp file (temp.txt) and purge file (purge.txt) I compare the data in the temp file against the purge file and if the record exists in both the files I do not add the data, if the record in the temp file does not exist in the purge file, I append the data to the purge file. When...
  10. jessiejane

    Email Functionality

    If there are 50 employess with 'Inactive' status then 50 emails nees to be sent to their respective managers. Would this be possible in Cognos using script/Event studio..etc. I looked at event studio but I need to hard code the email address and also body there, but I have get the email...
  11. jessiejane

    Email Functionality

    I looked at event studio but I have a question. The recipent names are different eveytime the report runs, how would I dynamically get the recipient names when the report runs. Any help is appreciated?
  12. jessiejane

    Email Functionality

    I am new to Cognos...and recently started working on a report. In cognos 8.4, would it be possible to send an email if a particular condition in a report occurs. For example:- We have a report which has employee data such as emp ID, emp name, emp staus, emp manager, emp dept....etc The...
  13. jessiejane

    Delete first 15 files in the folder from the current Date

    Hey the second method worked well but I still have one more issue. If the date on the file is less than 15 days then it deletes the file. But how would I take care of weekends. The weekend should be removed from those 15 days. How would I do that? If FileInfoDate <b> Now.AddDays(-15) </b>...
  14. jessiejane

    Delete first 15 files in the folder from the current Date

    The archive folder has many files. I need only the last 15 days files(for example: Dec 15-Jan1) in the archive folder and need to delete the remaining files. The process (The delete program) runs once a week, so it check the last 15 days files and deletes the files which are older than 15...
  15. jessiejane

    Delete first 15 files in the folder from the current Date

    I have an archive folder with the files in it. The files are in the format of NJDAT120909.txt format. i.e. NJDAT+Date.txt The archive folder has many files. The file is not placed during weekends. Only weekdays the file is placed in the archive folder For example: ---Nov 1st, sunday...
  16. jessiejane

    Date Format

    Figured out. Thanks
  17. jessiejane

    Date Format

    I have to get the previous date in MMDDYY format. I am trying this but getting output as 11DDYY. Not able to figure out why i am getting the value instead 0f 112309 ------------------------------- Dim strModDate as date Dim strTodayDate as string strModDate = DateTime.Today.AddDays(-1)...
  18. jessiejane

    Check the file exists

    That helps me. How would I test whether that file is empty or not? As the filename is Example112409.txt and I need to check with the startswith("example") and endswith(".txt") whether the file is empty or not? Any help...
  19. jessiejane

    Check the file exists

    I have a filename with Example112409.txt file in the folder. The date changes according to the current date. I file is palced everyday in the folder. How would I check the exists without checking the date. Like Startswith and endwith.. Any help...
  20. jessiejane

    Email to distribution List

    Hi, I need to send an email to the distribution list when the file is not found. When I checked with email server people - they said that they do not have particular server associated to the distribution list. Here is the code. How would I change it to fit my needs Any help is greatly...

Part and Inventory Search

Back
Top