infor.com
concierge
infor u
developer portal
Posts
Categories
Groups
Hubs
Developer
Healthcare
Hospitality
Public Sector
CloudSuites
Aerospace & Defense (LN)
Automotive (LN)
Chemicals (M3)
Corporate (FSM/HRT)
Distribution (Sx.e/CSD)
Distribution Enterprise (M3)
Engineering & Construction (LN)
Fashion (M3)
Food & Beverage (M3)
Healthcare (FSM/HRT)
Industrial (Syteline/CSI)
Industrial Enterprise (LN)
Manufacturing (M3)
Public Sector (FSM/HRT)
Solutions
Supply Chain Management (SCM)
Human Capital Management (HCM)
Events
Groups
Your Groups
User Groups
Migrated Forums
FSM/HCM/S3 - Infor Lawson 10.x
HCM/S3 - Learning and Development
HCM/S3 - Global HR
HCM/S3 - Talent Acquisition
HR Service Delivery
Human Capital Management (HCM) - EMEA
Infor Configuration Management for Service Industries
Lawson - Business Intelligence
Lawson - Financials
Lawson - Human Resources
Lawson - Supply Chain
Lawson - Supply Chain Management
Lawson - Technology
MSCM on Landmark
About
Community News
Email Community Support
Home
Groups
FACTS - Partner Community
Getting data file was last modified in ProvideX
salbritton
Does anyone have code/syntax they'd be willing to share that would allow me to open a file in ProvideX and determine the month, day, year a file was last modified? I've looked at the ProvideX manuals, but I'm not seeing what I need or the exact syntax to do this. I'd like to compare the value of this to DTE(0:"%Mz%Dz%Yz"). For example, this value for today (11/15/10) would be "111510".
Thanks in advance!
Brad Kraft, Forsythe Associates, Inc.
Find more posts tagged with
Comments
slonschek
Check the fin() function in the manual. Not sure which one you need, but here are the 3 that look most likely to answer your question.
UTC_CTime - Creation/changed time, UTC in seconds since Jan 1,1970
UTC_MTime - Last modified time, UTC in seconds since Jan 1,1970.
UTC_ATime - Last accessed time, UTC in seconds since Jan 1,1970.
Hope this helps.
James Crowther
Sequoia Group, Inc.
Legacy Contributor
this should get you close:
0010 floating point
0020 open (1)"prog/SM/SMU970"
0030 secs=dec($00$+mid(fin(1),5,4))
0040 days=int(secs/86400)
0050 secs=secs-(days*86400)
0060 this_date=jul(1970,1,1)+days
0070 print dte(this_date:"%Mz%Dz%Yz")
0080 hours=secs/3600
0090 print fn%time$(str(hours:"##.00"))
Important Links
Community Hubs
Discussion Forums
Groups
Community News
Popular Tags
CPQ: Ask a Colleague
FAQs, How-To, and Best Practices
Idea
Infor OS Portal
UI Design
CPQ: Tips and Tricks
Infor Homepages
Widget Development
Infor EPM Migration
Infor Ming.le