help with date fields

[MAINOH]

Hi,

I have two date fields pop_beg and pop_end. They both are formated at short date.

I need to combine the two fields such that that on my report the two dates can be displayed in one field with the days of each at the beginning.

For example:

pop_beg value 03/01/2006
pop_end value 03/31/2006

I would like to display on report as:
1 - 31 March 2006

Any help is greatly appreciated!

 

[Remou]

Try:
=Day(pop_beg) & " - " & Format(pop_end,"d mmmm yyyy")

 

[jfriedrich]

You may need to monkey with your date formats because Access goes based on your regional settings, but something like this is one way of doing it:

mid("03/01/2006",Instr(1,"03/01/2006", "/")+1, 2) & " - " & mid("03/31/2006",4,2) & " " & Format(#03/01/2006#, "mmmm") & " " & Mid("03/01/2006",7, 4)