Clear Date in .p program

Glad it finally worked out for ya!

On Tue, May 24, 2011 at 8:44 AM, Dave Hoffer <dshoff72@...> wrote:

>
>
> Thanks, it worked with ? only, not as "?" as I tried previously. I
> appreciate the groups input.
>
>
> [Non-text portions of this message have been removed]
>
>
>


[Non-text portions of this message have been removed]
I am trying to clear some date entries in a UD field within OrderDtl.Date01. I have tried "Assign orderDtl.Date01 = 00/00/000" with and with out parenthesis, just " ", 00's with no sucess. Does anyone know how to clear date entries within a date field?

Any feedback would be appreciated.

Dave Hoffer
Use a "?"



On Mon, May 23, 2011 at 2:38 PM, Rufus <dshoff72@...> wrote:

>
>
> I am trying to clear some date entries in a UD field within
> OrderDtl.Date01. I have tried "Assign orderDtl.Date01 = 00/00/000" with and
> with out parenthesis, just " ", 00's with no sucess. Does anyone know how to
> clear date entries within a date field?
>
> Any feedback would be appreciated.
>
> Dave Hoffer
>
>
>


[Non-text portions of this message have been removed]
When doing a dump and load, an empty field for dates are dumped and loaded
using a ? as the field value.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
Rufus
Sent: Monday, May 23, 2011 2:38 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Clear Date in .p program

I am trying to clear some date entries in a UD field within OrderDtl.Date01.
I have tried "Assign orderDtl.Date01 = 00/00/000" with and with out
parenthesis, just " ", 00's with no sucess. Does anyone know how to clear
date entries within a date field?

Any feedback would be appreciated.

Dave Hoffer





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

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/.
(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
--- In vantage@yahoogroups.com, "Ned" <TechnoBabbly@...> wrote:
>
> When doing a dump and load, an empty field for dates are dumped and
loaded
> using a ? as the field value.
>
> -----Original Message-----
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
Behalf Of
> Rufus
> Sent: Monday, May 23, 2011 2:38 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Clear Date in .p program
>
> I am trying to clear some date entries in a UD field within
OrderDtl.Date01.
> I have tried "Assign orderDtl.Date01 = 00/00/000" with and with out
> parenthesis, just " ", 00's with no sucess. Does anyone know how to
clear
> date entries within a date field?
>
> Any feedback would be appreciated.
>
> Dave Hoffer
>
>
>
>
>
> ------------------------------------
>
> 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/.
> (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
>


I tried ??//??/???? with and without " " also but with no success. See
.p program below.

ON WRITE OF OrderDtl OVERRIDE DO: END.

FOR EACH OrderDtl WHERE OrderDtl.Date01 = 01/01/2000 EXCLUSIVE-LOCK:

ASSIGN OrderDtl.Date01 = 00/00/000.



END.

QUIT.






thanks,




[Non-text portions of this message have been removed]
Not "??/??/????" just use "?"; it's all you need.

On Mon, May 23, 2011 at 4:50 PM, Rufus <dshoff72@...> wrote:

>
>
>
>
> --- In vantage@yahoogroups.com, "Ned" <TechnoBabbly@...> wrote:
> >
> > When doing a dump and load, an empty field for dates are dumped and
> loaded
> > using a ? as the field value.
> >
> > -----Original Message-----
> > From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On
> Behalf Of
> > Rufus
> > Sent: Monday, May 23, 2011 2:38 PM
> > To: vantage@yahoogroups.com
> > Subject: [Vantage] Clear Date in .p program
> >
> > I am trying to clear some date entries in a UD field within
> OrderDtl.Date01.
> > I have tried "Assign orderDtl.Date01 = 00/00/000" with and with out
> > parenthesis, just " ", 00's with no sucess. Does anyone know how to
> clear
> > date entries within a date field?
> >
> > Any feedback would be appreciated.
> >
> > Dave Hoffer
> >
> >
> >
> >
> >
> > ------------------------------------
> >
> > 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/.
> > (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
> >
>
> I tried ??//??/???? with and without " " also but with no success. See
> .p program below.
>
> ON WRITE OF OrderDtl OVERRIDE DO: END.
>
> FOR EACH OrderDtl WHERE OrderDtl.Date01 = 01/01/2000 EXCLUSIVE-LOCK:
>
> ASSIGN OrderDtl.Date01 = 00/00/000.
>
> END.
>
> QUIT.
>
> thanks,
>
> [Non-text portions of this message have been removed]
>
>
>


[Non-text portions of this message have been removed]
Thanks, it worked with ? only, not as "?" as I tried previously. I appreciate the groups input.

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