Service Connect Date Conversion and Null values

Yahoo Archive
1
I would do a choice (similar in structure to condition), use an = operator, tie your date node to the top, leave the bottom one blank (should show you "" - double quotes) path the data one way if it's not null and do your conversion, path it the other way and do something else.

Rob Bucek
Production Control Manager
PH: (715) 284-5376 ext 311
Mobile: (715)896-0590
FAX: (715)284-4084
[Description: cid:1.234354861@...]<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 carl.heeder
Sent: Wednesday, May 16, 2012 2:28 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Service Connect Date Conversion and Null values



I;ve also used the Conditional to test if ithe input field is blank. But how can I feed a Null value if the condition of the input field is blank?

Is it ? like 4GL or NULL (reserved word) or something else??

--- In vantage@yahoogroups.com<mailto:vantage%40yahoogroups.com>, "carl.heeder" <carl.heeder@...> wrote:
>
> I have an input field in a csv file that is either a date or a blank field. If it is not blank, I want to convert it to a date value and store it in a date field. If it is blank, I don;t want to store anything.
>
> I know how to do the string to date conversion but what do I use to make the decision about the blank?
>



[Non-text portions of this message have been removed]
2
I have an input field in a csv file that is either a date or a blank field. If it is not blank, I want to convert it to a date value and store it in a date field. If it is blank, I don;t want to store anything.

I know how to do the string to date conversion but what do I use to make the decision about the blank?
3
I;ve also used the Conditional to test if ithe input field is blank. But how can I feed a Null value if the condition of the input field is blank?

Is it ? like 4GL or NULL (reserved word) or something else??


--- In vantage@yahoogroups.com, "carl.heeder" <carl.heeder@...> wrote:
>
> I have an input field in a csv file that is either a date or a blank field. If it is not blank, I want to convert it to a date value and store it in a date field. If it is blank, I don;t want to store anything.
>
> I know how to do the string to date conversion but what do I use to make the decision about the blank?
>
4
In the workflow use a choice to check if the field is empty, if it is empty go one path, if it's not empty go another. That's how I would do it off the top of my head.



________________________________
From: carl.heeder <carl.heeder@...>
To: vantage@yahoogroups.com
Sent: Wednesday, May 16, 2012 3:27 PM
Subject: [Vantage] Re: Service Connect Date Conversion and Null values


I;ve also used the Conditional to test if ithe input field is blank. But how can I feed a Null value if the condition of the input field is blank?

Is it ? like 4GL or NULL (reserved word) or something else??


--- In vantage@yahoogroups.com, "carl.heeder" <carl.heeder@...> wrote:
>
> I have an input field in a csv file that is either a date or a blank field. If it is not blank, I want to convert it to a date value and store it in a date field. If it is blank, I don;t want to store anything.
>
> I know how to do the string to date conversion but what do I use to make the decision about the blank?
>




------------------------------------

Useful links for the Yahoo!Groups Vantage Board are: ( Note:Â You must have already linked your email address to a yahoo id to enable access. )
(1) To access the Files Section of our Yahoo!Group for Report Builder and Crystal Reports and other 'goodies', please goto: http://groups.yahoo.com/group/vantage/files/.%c2%a0
(2) To search through old msg's goto: http://groups.yahoo.com/group/vantage/messages
(3) To view links to Vendors that provide Vantage services goto: http://groups.yahoo.com/group/vantage/linksYahoo! Groups Links



[Non-text portions of this message have been removed]