< Back
Print

Format date with param value

Summary

With the Plugin “SC::Date – format date with param value” you can send a fixed date from a PIM attribute to the system. You can shift the date by the option of adding seconds to the date too.

Example

Insert the attribute and select the function “SC::Date – format date with param value” in the dropdown menu.

Click on the red marked button for the extended settings, a new window opens.
Here you set your value that should be transfered to your system.

Value Description Example
Add the date format here.
i.e. d.m.Y or Y-m-d\TH:i:s
here you define the date and the time

d = day; m = month; y = year;

\T = \separator

h = hour; i = minutes; s = seconds

d.m.y\(empty)H:i:s

For a detailed list of options, please click here

Add time units if you wish to shift your date (use negative numbers to substract the date).
Abbreviations:
y = Years     h = Hours
m = Months    i = Minutes
d = Days    s = Seconds
Here you can shift the date, insert the amount of seconds you want to shift your date. The seconds will be add to the date. If the date should go back in time then insert a negative number. 86400
Take current date, independend of the given value If enabled, this option always uses the current date (=date and time when the job using this data map is carried out. Basically, NOW.) and ignores the value from your date attribute. unchecked
Format result value using this plugin This plugin will be executed if it is required by a condition.

 

Value PIM

Results on the example from the Excel Connector

Results on the example from GenericJSON

Results in the log files

Details/limitations

No insert

If no value is given or no parameter is set, it will be returned either blank or in its unformatted form.

Why an “i” for the minute

It’s so that the “i” is used for the minute because the month has the “m”. This makes sure that the programm isn’t confused in either way.

Was this article helpful?
How can we improve this article?
Please submit the reason for your vote so that we can improve the article.
Table of Contents