Format Date with ABL Code

Thanks, good to know.



________________________________
From: Mike Anstey <manstey@...>
To: vantage@yahoogroups.com
Sent: Tuesday, February 28, 2012 2:40 PM
Subject: RE: [Vantage] Format Date with ABL Code

No problem. ISO-DATE already returns a string.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ted Koch
Sent: Tuesday, February 28, 2012 3:35 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Format Date with ABL Code



Â

Thanks Mike that did work.

STRING(ISO-DATE(JobMtl.ReqDate))

________________________________
From: Mike Anstey <manstey@...
<mailto:manstey%40flakeboard.ca> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>Â
Sent: Tuesday, February 28, 2012 2:24 PM
Subject: RE: [Vantage] Format Date with ABL Code

This is ISO standard, try ISO-DATE(JobMtl.ReqDate)

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of tkoch77
Sent: Tuesday, February 28, 2012 2:33 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Format Date with ABL Code

Â

I am trying to format a date to match YYYY-MM-DD (2012-02-28). How would
you do this? Would I have to create some variables and pick apart a date
like 02-28-2012 and piece it back together into another variable? I have
tried the examples below which got me nowhere.

Thanks,

Ted

STRING(JOBMTL.ReqDate, "9999-99-99")

STRING(JOBMTL.ReqDate, "YYYY-MM-DD")

STRING(JOBMTL.ReqDate) FORMAT "YYYY-MM-DD"

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

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

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/.
<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

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





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



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

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]
I am trying to format a date to match YYYY-MM-DD (2012-02-28). How would you do this? Would I have to create some variables and pick apart a date like 02-28-2012 and piece it back together into another variable? I have tried the examples below which got me nowhere.

Thanks,

Ted


STRING(JOBMTL.ReqDate, "9999-99-99")

STRING(JOBMTL.ReqDate, "YYYY-MM-DD")

STRING(JOBMTL.ReqDate) FORMAT "YYYY-MM-DD"
Obviously, this did work. Just wasn't sure if there was an easier way. Thanks.

ASSIGN dte = String(JobMtl.ReqDate, "99-99-9999").
ASSIGN month = SUBSTRING(dte,1,2).
ASSIGN day = SUBSTRING(dte,4,2).
ASSIGN yr = SUBSTRING(dte,7,4).

ASSIGN dte = yr + "-" + month + "-" + day.



________________________________
From: tkoch77 <tkoch77@...>
To: vantage@yahoogroups.com
Sent: Tuesday, February 28, 2012 1:32 PM
Subject: [Vantage] Format Date with ABL Code

I am trying to format a date to match YYYY-MM-DD (2012-02-28). How would you do this? Would I have to create some variables and pick apart a date like 02-28-2012 and piece it back together into another variable? I have tried the examples below which got me nowhere.

Thanks,

Ted


STRING(JOBMTL.ReqDate, "9999-99-99")

STRING(JOBMTL.ReqDate, "YYYY-MM-DD")

STRING(JOBMTL.ReqDate) FORMAT "YYYY-MM-DD"




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

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]
This is ISO standard, try ISO-DATE(JobMtl.ReqDate)



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of tkoch77
Sent: Tuesday, February 28, 2012 2:33 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Format Date with ABL Code





I am trying to format a date to match YYYY-MM-DD (2012-02-28). How would
you do this? Would I have to create some variables and pick apart a date
like 02-28-2012 and piece it back together into another variable? I have
tried the examples below which got me nowhere.

Thanks,

Ted

STRING(JOBMTL.ReqDate, "9999-99-99")

STRING(JOBMTL.ReqDate, "YYYY-MM-DD")

STRING(JOBMTL.ReqDate) FORMAT "YYYY-MM-DD"





[Non-text portions of this message have been removed]
Thanks Mike that did work.

STRING(ISO-DATE(JobMtl.ReqDate))



________________________________
From: Mike Anstey <manstey@...>
To: vantage@yahoogroups.com
Sent: Tuesday, February 28, 2012 2:24 PM
Subject: RE: [Vantage] Format Date with ABL Code

This is ISO standard, try ISO-DATE(JobMtl.ReqDate)



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of tkoch77
Sent: Tuesday, February 28, 2012 2:33 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Format Date with ABL Code



Â

I am trying to format a date to match YYYY-MM-DD (2012-02-28). How would
you do this? Would I have to create some variables and pick apart a date
like 02-28-2012 and piece it back together into another variable? I have
tried the examples below which got me nowhere.

Thanks,

Ted

STRING(JOBMTL.ReqDate, "9999-99-99")

STRING(JOBMTL.ReqDate, "YYYY-MM-DD")

STRING(JOBMTL.ReqDate) FORMAT "YYYY-MM-DD"





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



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

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]
No problem. ISO-DATE already returns a string.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Ted Koch
Sent: Tuesday, February 28, 2012 3:35 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Format Date with ABL Code





Thanks Mike that did work.

STRING(ISO-DATE(JobMtl.ReqDate))

________________________________
From: Mike Anstey <manstey@...
<mailto:manstey%40flakeboard.ca> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Tuesday, February 28, 2012 2:24 PM
Subject: RE: [Vantage] Format Date with ABL Code

This is ISO standard, try ISO-DATE(JobMtl.ReqDate)

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of tkoch77
Sent: Tuesday, February 28, 2012 2:33 PM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Format Date with ABL Code



I am trying to format a date to match YYYY-MM-DD (2012-02-28). How would
you do this? Would I have to create some variables and pick apart a date
like 02-28-2012 and piece it back together into another variable? I have
tried the examples below which got me nowhere.

Thanks,

Ted

STRING(JOBMTL.ReqDate, "9999-99-99")

STRING(JOBMTL.ReqDate, "YYYY-MM-DD")

STRING(JOBMTL.ReqDate) FORMAT "YYYY-MM-DD"

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

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

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/.
<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

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





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