x Want to participate? Join the group to interact
  • State Verified Answer
  • +1 person also asked this people also asked this
  • Replies 2 replies
  • Answers 1 answer
  • Subscribers 139 subscribers
  • Views 432 views
  • Users 0 members are here
Browse Forums
Announcements
237
topics
29
replies
General Discussion
5k
topics
13k
replies
Sage Data & Analytics
56
topics
95
replies
Sage Enterprise Intelligence
211
topics
418
replies
Sage Intelligence Reporting
121
topics
322
replies
N2XF3

retrieve file creation date

SOLVED
Posted By

Hello,

I would like to know if it is possible to retrieve file creation date from script.
Example C:\SAFEX3\... or C:\Test\myfile.txt

the goal would be to delete files older than 3 months so that they are not imported by a reccuring task.

Is it possible ? do I need to use a batch file?

Thanks !

Parents
  • +1
    verified answer

    You can make use of the VOLUME class to get the information you need, remember that the area you are the file is located needs to be defined as a "Sage X3 storage area" and/or the is must be defined in the runtime sandbox configuration file. The below will return the date the file created as a datetime value. 

    local Integer XASTATUS
    local Datetime XDATETIME
    local Char XVOLUME
    local Char XFILENAME
    [L]XVOLUME = "TMP" # X3 Storage area name
    [L]XFILENAME = "myfile.txt" # File name + extension

    [L]XASTATUS = Func ASYRSTO.GETFILEDATETIME([L]XVOLUME, [L]XFILENAME, [L]XDATETIME)

Reply
  • +1
    verified answer

    You can make use of the VOLUME class to get the information you need, remember that the area you are the file is located needs to be defined as a "Sage X3 storage area" and/or the is must be defined in the runtime sandbox configuration file. The below will return the date the file created as a datetime value. 

    local Integer XASTATUS
    local Datetime XDATETIME
    local Char XVOLUME
    local Char XFILENAME
    [L]XVOLUME = "TMP" # X3 Storage area name
    [L]XFILENAME = "myfile.txt" # File name + extension

    [L]XASTATUS = Func ASYRSTO.GETFILEDATETIME([L]XVOLUME, [L]XFILENAME, [L]XDATETIME)

Children
No Data

*Community Hub is the new name for Sage City