Combine 2 fields

[cameron.scrimgeour]

I have a begin_date field and an end_date field

I want to combine the day of the begin_date and the day of the end_date into one field...


Currently-

Begin_date End_date
01-Dec-2008 05-Dec-2008


Wanting -

01-05

 

[Extra_Cover]

Try:

Format(begin_date,"dd") & "-" & Format(end_date,"dd")

 

[DCrake]

Easy, but what's the object of the exercise? Is it cosmetic or are you planning to use it somewhere? What heppens if you select

25/12/2008 01/01/2009 the days will not be in sequence?


Solution:

Format(StartDate,"dd") & " - " & Format(EndDate,"dd")