Search results for query: *

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

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...

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...

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...

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 =...

Doesn't work any ideas please.

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

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...

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...

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...

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?

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...

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>...

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...

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...

Figured out. Thanks

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)...

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...

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...

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...