Epicor 9 Attachments

Try the following.

 

date("01-01-20" + substr(string(-file-.sysrevid),1,2)) - 1 + int(substr(string(-file-.sysrevid),3,3))

 

It'll return 01/02/14 for 140020000 but 12/31/199 for 0.

I am trying to find a good way to pull a system date of when an attachment was placed on a Sales Order.  I am pulling my info from the XFileAttch and XFileRef table but there is not reference to a transaction date or system time.  I tried linking the PartTran a crazy way but it is just pulling the tran date from the Sales Order itself not the attachment transaction.
 
Is there a way to set a BPM or BAM to send an alert when an attachment gets attached to a Sales Order?  I looked at it a littel but can't quite get the table right.
 
Thanks Kim
SysRevID, which is on almost all tables, is made up of two digit year followed by three digit Julian day followed by four digit counter within the day. Although it's updated anytime the record is changed, in the case of the file attachments files, it should be the date the file was attached.
Is there a way to convert this to a date format? 
On Wednesday, May 7, 2014 3:25 PM, "bluewine@..." <bluewine@...> wrote:
 
<div id="ygrps-yiv-70065314yiv8622169193ygrp-text">
  
  
  <div>SysRevID, which is on almost all tables,&nbsp;is made up of two digit year followed by three digit Julian day followed by four digit counter within the day. Although it&#39;s updated anytime the record is changed, in the case of the file attachments files,&nbsp;it should be the date the file was attached.</div>

</div>
 


<div style="height:0px;color:rgb(255, 255, 255);"></div></div>
#ygrps-yiv-70065314 #ygrps-yiv-70065314yiv8622169193 #ygrps-yiv-70065314yiv8622169193 -- #ygrps-yiv-70065314yiv8622169193ygrp-mkp { border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}

#ygrps-yiv-70065314 #ygrps-yiv-70065314yiv8622169193 #ygrps-yiv-70065314yiv8622169193ygrp-mkp hr {
border:1px solid #d8d8d8;}

#ygrps-yiv-70065314 #ygrps-yiv-70065314yiv8622169193 #ygrps-yiv-70065314yiv8622169193ygrp-mkp #ygrps-yiv-70065314yiv8622169193hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}

#ygrps-yiv-70065314 #ygrps-yiv-70065314yiv8622169193 #ygrps-yiv-70065314yiv8622169193ygrp-mkp #ygrps-yiv-70065314yiv8622169193ads {
margin-bottom:10px;}

#ygrps-yiv-70065314 #ygrps-yiv-70065314yiv8622169193 #ygrps-yiv-70065314yiv8622169193ygrp-mkp .ygrps-yiv-70065314yiv8622169193ad {
padding:0 0;}

#ygrps-yiv-70065314 #ygrps-yiv-70065314yiv8622169193 #ygrps-yiv-70065314yiv8622169193ygrp-mkp .ygrps-yiv-70065314yiv8622169193ad p {
margin:0;}

#ygrps-yiv-70065314 #ygrps-yiv-70065314yiv8622169193 #ygrps-yiv-70065314yiv8622169193ygrp-mkp .ygrps-yiv-70065314yiv8622169193ad a {
color:#0000ff;text-decoration:none;}
#ygrps-yiv-70065314 #ygrps-yiv-70065314yiv8622169193 #ygrps-yiv-70065314yiv8622169193ygrp-sponsor #ygrps-yiv-70065314yiv8622169193ygrp-lc {
font-family:Arial;}

#ygrps-yiv-70065314 #ygrps-yiv-70065314yiv8622169193 #ygrps-yiv-70065314yiv8622169193ygrp-sponsor #ygrps-yiv-70065314yiv8622169193ygrp-lc #ygrps-yiv-70065314yiv8622169193hd {
margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}

#ygrps-yiv-70065314 #ygrps-yiv-70065314yiv8622169193 #ygrps-yiv-70065314yiv8622169193ygrp-sponsor #ygrps-yiv-70065314yiv8622169193ygrp-lc .ygrps-yiv-70065314yiv8622169193ad {
margin-bottom:10px;padding:0 0;}

#ygrps-yiv-70065314 #ygrps-yiv-70065314yiv8622169193 #ygrps-yiv-70065314yiv8622169193actions {
font-family:Verdana;font-size:11px;padding:10px 0;}

#ygrps-yiv-70065314 #ygrps-yiv-70065314yiv8622169193 #ygrps-yiv-70065314yiv8622169193activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}

#ygrps-yiv-70065314 #ygrps-yiv-70065314yiv8622169193 #ygrps-yiv-70065314yiv8622169193activity span {
font-weight:700;}

#ygrps-yiv-70065314 #ygrps-yiv-70065314yiv8622169193 #ygrps-yiv-70065314yiv8622169193activity span:first-child {
text-transform:uppercase;}

#ygrps-yiv-70065314 #ygrps-yiv-70065314yiv8622169193 #ygrps-yiv-70065314yiv8622169193activity span a {
color:#5085b6;text-decoration:none;}

#ygrps-yiv-70065314 #ygrps-yiv-70065314yiv8622169193 #ygrps-yiv-70065314yiv8622169193activity span span {
color:#ff7900;}

#ygrps-yiv-70065314 #ygrps-yiv-70065314yiv8622169193 #ygrps-yiv-70065314yiv8622169193activity span .ygrps-yiv-70065314yiv8622169193underline {
text-decoration:underline;}

#ygrps-yiv-70065314 #ygrps-yiv-70065314yiv8622169193 .ygrps-yiv-70065314yiv8622169193attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}

#ygrps-yiv-70065314 #ygrps-yiv-70065314yiv8622169193 .ygrps-yiv-70065314yiv8622169193attach div a {
text-decoration:none;}

#ygrps-yiv-70065314 #ygrps-yiv-70065314yiv8622169193 .ygrps-yiv-70065314yiv8622169193attach img {
border:none;padding-right:5px;}

#ygrps-yiv-70065314 #ygrps-yiv-70065314yiv8622169193 .ygrps-yiv-70065314yiv8622169193attach label {
display:block;margin-bottom:5px;}

#ygrps-yiv-70065314 #ygrps-yiv-70065314yiv8622169193 .ygrps-yiv-70065314yiv8622169193attach label a {
text-decoration:none;}

#ygrps-yiv-70065314 #ygrps-yiv-70065314yiv8622169193 blockquote {
margin:0 0 0 4px;}

#ygrps-yiv-70065314 #ygrps-yiv-70065314yiv8622169193 .ygrps-yiv-70065314yiv8622169193bold {
font-family:Arial;font-size:13px;font-weight:700;}

#ygrps-yiv-70065314 #ygrps-yiv-70065314yiv8622169193 .ygrps-yiv-70065314yiv8622169193bold a {
text-decoration:none;}

#ygrps-yiv-70065314 #ygrps-yiv-70065314yiv8622169193 dd.ygrps-yiv-70065314yiv8622169193last p a {
font-family:Verdana;font-weight:700;}

#ygrps-yiv-70065314 #ygrps-yiv-70065314yiv8622169193 dd.ygrps-yiv-70065314yiv8622169193last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}

#ygrps-yiv-70065314 #ygrps-yiv-70065314yiv8622169193 dd.ygrps-yiv-70065314yiv8622169193last p span.ygrps-yiv-70065314yiv8622169193yshortcuts {
margin-right:0;}

#ygrps-yiv-70065314 #ygrps-yiv-70065314yiv8622169193 div.ygrps-yiv-70065314yiv8622169193attach-table div div a {
text-decoration:none;}

#ygrps-yiv-70065314 #ygrps-yiv-70065314yiv8622169193 div.ygrps-yiv-70065314yiv8622169193attach-table {
width:400px;}

#ygrps-yiv-70065314 #ygrps-yiv-70065314yiv8622169193 div.ygrps-yiv-70065314yiv8622169193file-title a, #ygrps-yiv-70065314 #ygrps-yiv-70065314yiv8622169193 div.ygrps-yiv-70065314yiv8622169193file-title a:active, #ygrps-yiv-70065314 #ygrps-yiv-70065314yiv8622169193 div.ygrps-yiv-70065314yiv8622169193file-title a:hover, #ygrps-yiv-70065314 #ygrps-yiv-70065314yiv8622169193 div.ygrps-yiv-70065314yiv8622169193file-title a:visited {
text-decoration:none;}

#ygrps-yiv-70065314 #ygrps-yiv-70065314yiv8622169193 div.ygrps-yiv-70065314yiv8622169193photo-title a, #ygrps-yiv-70065314 #ygrps-yiv-70065314yiv8622169193 div.ygrps-yiv-70065314yiv8622169193photo-title a:active, #ygrps-yiv-70065314 #ygrps-yiv-70065314yiv8622169193 div.ygrps-yiv-70065314yiv8622169193photo-title a:hover, #ygrps-yiv-70065314 #ygrps-yiv-70065314yiv8622169193 div.ygrps-yiv-70065314yiv8622169193photo-title a:visited {
text-decoration:none;}

#ygrps-yiv-70065314 #ygrps-yiv-70065314yiv8622169193 div#ygrps-yiv-70065314yiv8622169193ygrp-mlmsg #ygrps-yiv-70065314yiv8622169193ygrp-msg p a span.ygrps-yiv-70065314yiv8622169193yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}

#ygrps-yiv-70065314 #ygrps-yiv-70065314yiv8622169193 .ygrps-yiv-70065314yiv8622169193green {
color:#628c2a;}

#ygrps-yiv-70065314 #ygrps-yiv-70065314yiv8622169193 .ygrps-yiv-70065314yiv8622169193MsoNormal {
margin:0 0 0 0;}

#ygrps-yiv-70065314 #ygrps-yiv-70065314yiv8622169193 o {
font-size:0;}

#ygrps-yiv-70065314 #ygrps-yiv-70065314yiv8622169193 #ygrps-yiv-70065314yiv8622169193photos div {
float:left;width:72px;}

#ygrps-yiv-70065314 #ygrps-yiv-70065314yiv8622169193 #ygrps-yiv-70065314yiv8622169193photos div div {
border:1px solid #666666;height:62px;overflow:hidden;width:62px;}

#ygrps-yiv-70065314 #ygrps-yiv-70065314yiv8622169193 #ygrps-yiv-70065314yiv8622169193photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}

#ygrps-yiv-70065314 #ygrps-yiv-70065314yiv8622169193 #ygrps-yiv-70065314yiv8622169193reco-category {
font-size:77%;}

#ygrps-yiv-70065314 #ygrps-yiv-70065314yiv8622169193 #ygrps-yiv-70065314yiv8622169193reco-desc {
font-size:77%;}

#ygrps-yiv-70065314 #ygrps-yiv-70065314yiv8622169193 .ygrps-yiv-70065314yiv8622169193replbq {
margin:4px;}

#ygrps-yiv-70065314 #ygrps-yiv-70065314yiv8622169193 #ygrps-yiv-70065314yiv8622169193ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}

#ygrps-yiv-70065314 #ygrps-yiv-70065314yiv8622169193 #ygrps-yiv-70065314yiv8622169193ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}

#ygrps-yiv-70065314 #ygrps-yiv-70065314yiv8622169193 #ygrps-yiv-70065314yiv8622169193ygrp-mlmsg table {
font-size:inherit;font:100%;}

#ygrps-yiv-70065314 #ygrps-yiv-70065314yiv8622169193 #ygrps-yiv-70065314yiv8622169193ygrp-mlmsg select, #ygrps-yiv-70065314 #ygrps-yiv-70065314yiv8622169193 input, #ygrps-yiv-70065314 #ygrps-yiv-70065314yiv8622169193 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}

#ygrps-yiv-70065314 #ygrps-yiv-70065314yiv8622169193 #ygrps-yiv-70065314yiv8622169193ygrp-mlmsg pre, #ygrps-yiv-70065314 #ygrps-yiv-70065314yiv8622169193 code {
font:115% monospace;}

#ygrps-yiv-70065314 #ygrps-yiv-70065314yiv8622169193 #ygrps-yiv-70065314yiv8622169193ygrp-mlmsg * {
line-height:1.22em;}

#ygrps-yiv-70065314 #ygrps-yiv-70065314yiv8622169193 #ygrps-yiv-70065314yiv8622169193ygrp-mlmsg #ygrps-yiv-70065314yiv8622169193logo {
padding-bottom:10px;}

#ygrps-yiv-70065314 #ygrps-yiv-70065314yiv8622169193 #ygrps-yiv-70065314yiv8622169193ygrp-msg p a {
font-family:Verdana;}

#ygrps-yiv-70065314 #ygrps-yiv-70065314yiv8622169193 #ygrps-yiv-70065314yiv8622169193ygrp-msg p#ygrps-yiv-70065314yiv8622169193attach-count span {
color:#1E66AE;font-weight:700;}

#ygrps-yiv-70065314 #ygrps-yiv-70065314yiv8622169193 #ygrps-yiv-70065314yiv8622169193ygrp-reco #ygrps-yiv-70065314yiv8622169193reco-head {
color:#ff7900;font-weight:700;}

#ygrps-yiv-70065314 #ygrps-yiv-70065314yiv8622169193 #ygrps-yiv-70065314yiv8622169193ygrp-reco {
margin-bottom:20px;padding:0px;}

#ygrps-yiv-70065314 #ygrps-yiv-70065314yiv8622169193 #ygrps-yiv-70065314yiv8622169193ygrp-sponsor #ygrps-yiv-70065314yiv8622169193ov li a {
font-size:130%;text-decoration:none;}

#ygrps-yiv-70065314 #ygrps-yiv-70065314yiv8622169193 #ygrps-yiv-70065314yiv8622169193ygrp-sponsor #ygrps-yiv-70065314yiv8622169193ov li {
font-size:77%;list-style-type:square;padding:6px 0;}

#ygrps-yiv-70065314 #ygrps-yiv-70065314yiv8622169193 #ygrps-yiv-70065314yiv8622169193ygrp-sponsor #ygrps-yiv-70065314yiv8622169193ov ul {
margin:0;padding:0 0 0 8px;}

#ygrps-yiv-70065314 #ygrps-yiv-70065314yiv8622169193 #ygrps-yiv-70065314yiv8622169193ygrp-text {
font-family:Georgia;}

#ygrps-yiv-70065314 #ygrps-yiv-70065314yiv8622169193 #ygrps-yiv-70065314yiv8622169193ygrp-text p {
margin:0 0 1em 0;}

#ygrps-yiv-70065314 #ygrps-yiv-70065314yiv8622169193 #ygrps-yiv-70065314yiv8622169193ygrp-text tt {
font-size:120%;}

#ygrps-yiv-70065314 #ygrps-yiv-70065314yiv8622169193 #ygrps-yiv-70065314yiv8622169193ygrp-vital ul li:last-child {
border-right:none !important;}
#ygrps-yiv-70065314