Number of days in a mont for a year 1

[thisisboni]

Hi:

I'm on CR 10 and Oracle 9i

in a table I have a varchar field as 'yyyy_mm'.
It contains the4 digit year value and the month value separated by '-' eg: 2006-02, 2006-11, etc...

I was looking to find the number of days that month for that year had ... that is ... for 2006-02 ... it is 28,
2006-11 it is 30 etc..

Please let me know if there is an inbuilt function and/or any custom function.

Thanks

 

[synapsevampire]

No built in function for this, create a formula of:

whileprintingrecords;
numbervar days:=0;
datevar TheDate := dateserial(val(left({table.field},4)),val(mid({table.field},6,2))+1,1)-1;
day(TheDate)

-k

 

[thisisboni]

Thanks ! this works !