Please note that VisualCron support is not actively monitoring this community forum. Please use our contact page for contacting the VisualCron support directly.


CMBI-IT
2019-10-22T06:28:10Z
1. How to display date format for yesterday (T-1) as MMM,
E.g. Assume today is 01 Oct 2019, then we would like to display as "Sep" (because 'yesterday' is 30 Sep 2019).


2. How to display date format for yesterday (T-1) as single digit d.
E.g. Assume today is 08 Oct 2019, then we would like to display "7" (because 'yesterday' is 07 Oct 2019).
E.g. Assume today is 22 Oct 2019, then we would like to display "21" (because 'yesterday' is 21 Oct 2019).
Sponsor
Forum information
Support
2019-10-22T11:59:56Z
Issue solved via online support chat.
Michael
Support
http://www.visualcron.com 

Please like  VisualCron on facebook!
Gary_W
2019-10-23T14:23:12Z
Why not include the answers in your post so future searchers can find it?
Support
2019-10-23T14:52:36Z
1) {DATEADD(Days|2019-10-22 10:10|yyyy-MM-dd HH:mm|-1|yyyy-MMM-dd HH:mm)} for example, shows desired date

2) {STRING(Trim|{DATENOWADD(Days|-1| d)})} for example, shows desired date with single digit
Michael
Support
http://www.visualcron.com 

Please like  VisualCron on facebook!
Scroll to Top