status

[PaulG.]

Just to throw in my $0.02, you are giving a non-Excel file a .xls extension.

Don't do that. Please don't do that.

[Zahkay]

Hello

WHat do u mean by dont do that sir

Any other option

[Dennis_Knutson]

Save the file with a .txt extension or create an actual excel file with ActiveX properties and methods.

Before starting your project, you should have asked for help in the design. Choosing a text file format, in my opinion, was a mistake. If you had used an actual database or Excel file, you wouldn't be hacking your way through the mess of code you now have. I'm not sure why you won't answer some of the questions that you have been asked or take the advice you've been given.

[Zahkay]

Hello sir

I have been going through everybody comment and try my best to understand what i can do and implement in my project.

My supervisor does not allow me to store in notepad ( text file). I have to use excel to do so.

I came across this VI which i found interesting and was one suggestion from the above members. but i dont know how to modify

and implement this in my project

 refering to this link

http://lavag.org/topic/15034-timestamp-support-for-format-into-string-scan-variant-from-string-strin...

I am not able to attach and post the VI. it is within this link

[RavensFan]

You can't store stuff in notepad.  Notepad is an application intended to open and save text files.

Your supervisor says you can't store stuff in text files, but that is exactly what you are doing when you use Write toSpreadsheet File and Read from Spreadsheet File.  Giving it an .xls extension doesn't magically turn it into an Excel file.  It just makes it a text file that has an inaccurate extension which is why you should'nt name it .xls.

I have no idea how that link to the Lava thread is supposed to help you with your problem.

[billko]

Seems to me to be artificial constraints - kind of like a homework assignment or a test.  In this case, you would fail for the reason mentioned multiple times before: you have a text file, regardless of the extension you give it.

[Zahkay]

Thank you all for your advice. I shall recheck myself onto the coding. 

Thank you. i did learn the technical term here

thanks all.

[Zahkay]

hello everyone

referring to each comment, i try to reset my aim on the status 

which mean if due date arrives, notification should be pop out..

however since 7 days were given to the student, i make the coding like this.

but in some i am getting error and i dont know hw to test it..

is it correct.

[Dennis_Knutson]

Quite frankly, none of that makes any sense to me. It looks like you have completely ignored the advice that I and others have given you.

Your main VI still has not been provided. You are reading from one file and writing to another. If your main truly has a checkout state, the new status would always be 'checked out'. Pointless to check if it is overdue. The file with the status and due date (which is the only file you should be reading/writing), does not have a time for due date, only a date. Your main should only check for overdue items once a day. If an item is not overdue at 1 am, it won't be overdue at 1 pm.

Your coding is questionable as well as the overall design. You need to make some fundamental changes and provide the information that has been repeatedly asked for.

I've spent way too much time saying the same things over and over again and being ignored. I can't help any more. Good luck.

[Zahkay]

Dear Sir,

i appreciate your help. I dont thnk i ignore. refereing from the start of this conversation, mostly discussion was 

in term of the format how i store my data, delimited txt, .csv or by excel.xls

Dear everyone, i am stuck in this VI that why i am slow to understand each meaning as all members have different point of view

I am unable to upload my whole VI here, when i am uploading, it is saying error...

I apologise if i didnt follow some guideline. i am just trying to understand but all point of views are different..

But thanks if somebody here can give me with a sample Vi, this will help. I was about to follow a course but with limited time , i am

not able to do so.. This is why there is many thread of my question you will see because i still cannot solve

But i will try my best even though.