Finding date of a file in runtime

Posted on 2001-06-20
Medium Priority
Last Modified: 2013-12-26
I'm using PB 7.0 and would like to know how to find out the date and time of a file (*.txt/*.pbd) during runtime.  URGENT!!

Thank you,
Question by:baskar
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 2

Author Comment

ID: 6209593
pls mail to baskar@comline.com.my

Expert Comment

ID: 6209676
If you saved your  *.txt file as "tab Separated"  file. Make a datastore from this file and you can access any time to your datastore.  (ImportFile function for *.Txt file). The count of your datastore columns must be equal to the *.txt file columns.

Author Comment

ID: 6209692
Hi Bhatti,

No I won't be reading the file, I mean the contents. I just wants to know the last edited date and time of the file.
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!


Author Comment

ID: 6209736
Hi Bhatti,

No I won't be reading the file, I mean the contents. I just wants to know the last edited date and time of the file.

Expert Comment

ID: 6209897
Try with API/SDK functions to find data and time of file attributes.

Accepted Solution

Miguel_Angel earned 400 total points
ID: 6213773
If you have worked with API's before you wouldn't find any problems with that.

You need to use 2 API's:

BOOL GetFileTime(
  HANDLE hFile,                 // handle to file
  LPFILETIME lpCreationTime,    // creation time
  LPFILETIME lpLastAccessTime,  // last access time
  LPFILETIME lpLastWriteTime    // last write time

BOOL FileTimeToSystemTime(
  CONST FILETIME *lpFileTime,  // file time to convert
  LPSYSTEMTIME lpSystemTime    // receives system time
And for working with them you need this previus created structures:

     long v_lowdatetime
     long v_highdatetime
     int v_year
     int v_month
     int v_dayofweek
     int v_day
     int v_hour
     int v_minute
     int v_second
     int v_millisecond
And the script would look like:

string filename
long   fileid

st_filetime   creationtime, lastaccesstime, lastwritetime
st_systemtime systemtime

filename = "c:\testfile.txt"
fileid   = fileopen(filename)

getfiletime(fileid, creationtime, lastaccesstime, lastwritetime)

filetimetosystemtime(creationtime, systemtime)

And voila, you have in systemtime.v_year, systemtime.v_month, and so on. Of course several error filters should help too, but this isbasically what you need to know.

Good luck.

Author Comment

ID: 6251967
Thank you very much for your guidance. Sorry for the delay in getting back.

Featured Post

On Demand Webinar - Networking for the Cloud Era

This webinar discusses:
-Common barriers companies experience when moving to the cloud
-How SD-WAN changes the way we look at networks
-Best practices customers should employ moving forward with cloud migration
-What happens behind the scenes of SteelConnect’s one-click button

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Programmer's Notepad is, one of the best free text editing tools available, simply because the developers appear to have second-guessed every weird problem or issue a programmer is likely to run into. One of these problems is selecting and deleti…
Jaspersoft Studio is a plugin for Eclipse that lets you create reports from a datasource.  In this article, we'll go over creating a report from a default template and setting up a datasource that connects to your database.
This tutorial covers a step-by-step guide to install VisualVM launcher in eclipse.
The viewer will learn how to synchronize PHP projects with a remote server in NetBeans IDE 8.0 for Windows.
Suggested Courses

801 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question