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]
________________________________
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]