Analysis Date Question

[slickp]

Crystal 10

I have a field in a table called analysisperiod, which shows the month and year of each transaction as a number in this format, 200703 for March 2007.

I need to create a formula which uses the current date to create this number. I have extracted the month and year from current date using: Year(currentdate) and Month(currentdate). However i'm getting stuck on sticking them together as a number. Help?

 

[lbass]

Try:

year(currentdate)*100 + month(currentdate)

-LB

 

[slickp]

Quality mate, cheers