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?
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?