Fw: BAQ Calculated Field Help - concatonate dates

Yahoo Archive
1
I tried that (it works for you!?):

String( Year(PartTran.TranDate)) + String( Month(PartTran.TranDate))

But it does not work - i get a syntax error. Curious, what data type are you
using? Character? Any format?


Strange, but this works:Â

String( Year(PartTran.TranDate)) + String( Year(PartTran.TranDate))

and this:
Month(PartTran.TranDate)

What am I missing?


This
Â
Keith Walter
Vantage Coordinator
Norgren Automation Solutions, Saline Division
keith.walter@...




________________________________
From: cooner_55421 <cooner_55421@...>
To: vantage@yahoogroups.com
Sent: Tue, January 4, 2011 2:30:46 PM
Subject: [Vantage] Re: Fw: BAQ Calculated Field Help - concatonate dates

Â
This seems to work for me:

String( Year(PartTran.TranDate)) + String( Month(PartTran.TranDate))
I
Except I don't get a leading zero for the month
20104
20094
20108
etc...

--- In vantage@yahoogroups.com, Keith Walter <keithfwalter@...> wrote:
>
> Happy New Year everyone!
>
> I need help!� I am trying to create a calculated field in a BAQ to create
>some
>
> custom date strings.� For example: I want to take a date field, and use it to
>
> display YEAR AND MONTH, like this:
> �
> YYYYMM� (e.g. 201101 would be this month)
> �
> I have tried this:
> �
> year(PartTran.TranDate) + month(PartTran.TranDate)
> �
> and this:
> �
> year(PartTran.TranDate)�& month(PartTran.TranDate)
> �
> Both of these functions work independantly, but i cannot figure out how to
> concatonate them together in a BAQ!
> �
> �
> Any suggestions!?
>
>
> �
> Keith Walter
> Vantage Coordinator
> Norgren Automation Solutions, Saline Division
> keith.walter@...
>
>
>
>
>
> [Non-text portions of this message have been removed]
>







[Non-text portions of this message have been removed]
2
Happy New Year everyone!

I need help! I am trying to create a calculated field in a BAQ to create some
custom date strings. For example: I want to take a date field, and use it to
display YEAR AND MONTH, like this:
Â
YYYYMMÂ (e.g. 201101 would be this month)
Â
I have tried this:
Â
year(PartTran.TranDate) + month(PartTran.TranDate)
Â
and this:
Â
year(PartTran.TranDate)Â & month(PartTran.TranDate)
Â
Both of these functions work independantly, but i cannot figure out how to
concatonate them together in a BAQ!
Â
Â
Any suggestions!?


Â
Keith Walter
Vantage Coordinator
Norgren Automation Solutions, Saline Division
keith.walter@...





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