Articles in this section

Some formulas to help build the DocumentKey with the creation date for the documents to extract

Avatar
John
  • Updated
Follow
The code below returns the string "_20211223_135948" for the Notes document with creation date "23/12/2021 13:59:48":
 
#################################################

_created:=@Created;
_year:=@Text(@Year(_created));
_month:=@Right("00"+@Text(@Month(_created));2);
_day:=@Right("00"+@Text(@Day(_created));2);
_hour:=@Right("00"+@Text(@Hour(_created));2);
_minute:=@Right("00"+@Text(@Minute(_created));2);
_second:=@Right("00"+@Text(@Second(_created));2);
"_"+_year+_month+_day+"_"+_hour+_minute+_second

#################################################
Example : 
mceclip0.png
 
Text format of the formula:
_created:=@Created;_year:=@Text(@Year(_created));_month:=@Right("00"+@Text(@Month(_created));2);_day:=@Right("00"+@Text(@Day(_created));2);_hour:=@Right("00"+@Text(@Hour(_created));2);_minute:=@Right("00"+@Text(@Minute(_created));2);_second:=@Right("00"+@Text(@Second(_created));2); form + "_" + _year + _month +_day + "_" + _hour + _minute + _second

Related articles

Comments

0 comments

Article is closed for comments.

Powered by Zendesk