Year-Month BAQ Calculated field

Yahoo Archive
1
I did this for some calc too (we are on 8.03.409C) and did if then

Month result < 10 = 0 & month result
Else month result

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of randyweb
Sent: Wednesday, November 09, 2011 11:05 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Year-Month BAQ Calculated field



v9.05.606

I used this calculated field in V8 before but it is not behaving the same way in v9:

string(Year(BookDtl.BookDate), "9999") + "-" + string(Month(BookDtl.BookDate), "99")

In v8x, the result would be 2011-01, 2011-02, etc. The purpose was to be able to group by the period.

But in v9, the result is 2011-1, 2011-2 which does not sort properly.

I believe the "99" should produce my desired result of 2 characters for the month.

Thanks in advance

Randy Weber



[Non-text portions of this message have been removed]
2
v9.05.606

I used this calculated field in V8 before but it is not behaving the same way in v9:

string(Year(BookDtl.BookDate), "9999") + "-" + string(Month(BookDtl.BookDate), "99")

In v8x, the result would be 2011-01, 2011-02, etc. The purpose was to be able to group by the period.

But in v9, the result is 2011-1, 2011-2 which does not sort properly.

I believe the "99" should produce my desired result of 2 characters for the month.

Thanks in advance

Randy Weber