Date Minus Functoid SC

Yahoo Archive
1
The obvious comment was intended as sarcasm! How are you coming along
with that day of the week calculation?



Rob Bucek

Manufacturing Engineer

PH: (715) 284-5376 ext 3111

Mobile: (715)896-0590

FAX: (715)284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site) <http://www.dsmfg.com/>





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of foamdesigncsw
Sent: Monday, April 19, 2010 9:13 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Date Minus Functoid SC





I would have never guessed that one i messed with it for 30 minutes
trying just 1 or 1D and everything else i could think of i would have
never come up with P1D...

~C

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> , "Rob
Bucek" <rbucek@...> wrote:
>
> If you want to subtract one day your format would be; link your date
> field (assuming it's a date format) to the top link, your format for
the
> bottom in this example would be P1D (obvious right?).
>
>
>
> Rob Bucek
>
> Manufacturing Engineer
>
> PH: (715) 284-5376 ext 3111
>
> Mobile: (715)896-0590
>
> FAX: (715)284-4084
>
> <http://www.dsmfg.com/>
>
> (Click the logo to view our site) <http://www.dsmfg.com/>
>
>
>
>
>
> From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
> Of foamdesigncsw
> Sent: Monday, April 19, 2010 6:42 AM
> To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
> Subject: [Vantage] Date Minus Functoid SC
>
>
>
>
>
> I cant figure out how to use the date minus functoid in SC any
guidance.
> I assume the date goes in the first field but i can't figure out what
to
> put in the second field to subtract the date by 1 day.
>
> ~C
>
>
>
>
>
> [Non-text portions of this message have been removed]
>





[Non-text portions of this message have been removed]
2
I cant figure out how to use the date minus functoid in SC any guidance. I assume the date goes in the first field but i can't figure out what to put in the second field to subtract the date by 1 day.

~C
3
I know that on the "addDurationToDateTime" functiod, the first argument is the date, and the second is the duration. The formatting is a little strange. To add 1 day, you would use "P1D". I would guess to subtract a day, you would use "P-1D" as the second argument.

--- In vantage@yahoogroups.com, "foamdesigncsw" <foamdesigncsw@...> wrote:
>
> I cant figure out how to use the date minus functoid in SC any guidance. I assume the date goes in the first field but i can't figure out what to put in the second field to subtract the date by 1 day.
>
> ~C
>
4
Gee, how intuitive. :-)







________________________________

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of mattcald_73
Sent: Monday, April 19, 2010 9:45 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Date Minus Functoid SC





I know that on the "addDurationToDateTime" functiod, the first argument
is the date, and the second is the duration. The formatting is a little
strange. To add 1 day, you would use "P1D". I would guess to subtract a
day, you would use "P-1D" as the second argument.

--- In vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ,
"foamdesigncsw" <foamdesigncsw@...> wrote:
>
> I cant figure out how to use the date minus functoid in SC any
guidance. I assume the date goes in the first field but i can't figure
out what to put in the second field to subtract the date by 1 day.
>
> ~C
>





[Non-text portions of this message have been removed]
5
If you want to subtract one day your format would be; link your date
field (assuming it's a date format) to the top link, your format for the
bottom in this example would be P1D (obvious right?).



Rob Bucek

Manufacturing Engineer

PH: (715) 284-5376 ext 3111

Mobile: (715)896-0590

FAX: (715)284-4084

<http://www.dsmfg.com/>

(Click the logo to view our site) <http://www.dsmfg.com/>





From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of foamdesigncsw
Sent: Monday, April 19, 2010 6:42 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Date Minus Functoid SC





I cant figure out how to use the date minus functoid in SC any guidance.
I assume the date goes in the first field but i can't figure out what to
put in the second field to subtract the date by 1 day.

~C





[Non-text portions of this message have been removed]
6
I would have never guessed that one i messed with it for 30 minutes trying just 1 or 1D and everything else i could think of i would have never come up with P1D...

~C

--- In vantage@yahoogroups.com, "Rob Bucek" <rbucek@...> wrote:
>
> If you want to subtract one day your format would be; link your date
> field (assuming it's a date format) to the top link, your format for the
> bottom in this example would be P1D (obvious right?).
>
>
>
> Rob Bucek
>
> Manufacturing Engineer
>
> PH: (715) 284-5376 ext 3111
>
> Mobile: (715)896-0590
>
> FAX: (715)284-4084
>
> <http://www.dsmfg.com/>
>
> (Click the logo to view our site) <http://www.dsmfg.com/>
>
>
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
> Of foamdesigncsw
> Sent: Monday, April 19, 2010 6:42 AM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Date Minus Functoid SC
>
>
>
>
>
> I cant figure out how to use the date minus functoid in SC any guidance.
> I assume the date goes in the first field but i can't figure out what to
> put in the second field to subtract the date by 1 day.
>
> ~C
>
>
>
>
>
> [Non-text portions of this message have been removed]
>