Checkhead.Checkdate format

Yahoo Archive
1
That works just fine.
Thanks!
Jim

-----Original Message-----
From: Todd Caughey [mailto:caugheyt@...]
Sent: Tuesday, January 10, 2006 1:28 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Checkhead.Checkdate format

It's klutzy but...
SUBSTRING(Date,5,4) + SUBSTRING(Date,1,2) + SUBSTRING(Date,3,2) where 'Date'
is your calculated field date string.
-Todd C.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of
Moore, Jim (Anniston)
Sent: Tuesday, January 10, 2006 12:52 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Checkhead.Checkdate format


I have an RB report that uses string(checkhed.checkdate, '99999999') in
a calculated field expression. The output is MMDDYYYY.
Due to some changes in the way our bank wants the reporting done, it must be
YYYYMMDD.
Can this be changed and if so how?

Thanks,

Jim Moore
General Dynamics - OTS
2
I have an RB report that uses string(checkhed.checkdate, '99999999') in
a calculated field expression. The output is MMDDYYYY.
Due to some changes in the way our bank wants the reporting done, it must be
YYYYMMDD.
Can this be changed and if so how?

Thanks,

Jim Moore
General Dynamics - OTS




[Non-text portions of this message have been removed]
3
It's klutzy but...
SUBSTRING(Date,5,4) + SUBSTRING(Date,1,2) + SUBSTRING(Date,3,2)
where 'Date' is your calculated field date string.
-Todd C.

-----Original Message-----
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]On Behalf Of Moore, Jim (Anniston)
Sent: Tuesday, January 10, 2006 12:52 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Checkhead.Checkdate format


I have an RB report that uses string(checkhed.checkdate, '99999999') in
a calculated field expression. The output is MMDDYYYY.
Due to some changes in the way our bank wants the reporting done, it must be
YYYYMMDD.
Can this be changed and if so how?

Thanks,

Jim Moore
General Dynamics - OTS




[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/.
(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/links




SPONSORED LINKS
Manufacturing <http://groups.yahoo.com/gads?t=ms&k=Manufacturing+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=OG5F3819UOUOg63i0bu6kA> software Membership <http://groups.yahoo.com/gads?t=ms&k=Membership+database+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=N5BGdur84p-jyuOomcQdbQ> database software Database <http://groups.yahoo.com/gads?t=ms&k=Database+mortgage+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=8rvcSQnCqJhTCZu-0Si39A> mortgage software
Pda <http://groups.yahoo.com/gads?t=ms&k=Pda+database+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=u3KQrTRPAQfsWIT39aHDkg> database software Database <http://groups.yahoo.com/gads?t=ms&k=Database+management+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=R3CF3ODPY4gwjDZjykQYvw> management software Database <http://groups.yahoo.com/gads?t=ms&k=Database+marketing+software&w1=Manufacturing+software&w2=Membership+database+software&w3=Database+mortgage+software&w4=Pda+database+software&w5=Database+management+software&w6=Database+marketing+software&c=6&s=188&.sig=lmBkRUiBtvHI1u5dkymDcw> marketing software

_____

YAHOO! GROUPS LINKS



* Visit your group " vantage <http://groups.yahoo.com/group/vantage> " on the web.


* To unsubscribe from this group, send an email to:
vantage-unsubscribe@yahoogroups.com <mailto:vantage-unsubscribe@yahoogroups.com?subject=Unsubscribe>


* Your use of Yahoo! Groups is subject to the Yahoo! Terms of Service <http://docs.yahoo.com/info/terms/> .


_____




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