Dates Changing in Access

Hi Nicola

Thanks for your question

This can be done by using a combination of datepart() functions, string cocatenation, and cdate functions to format the date correctly.
I will write a some code to solve this and will post it here later today or tommorrow

Regards

Stephen

Hi Nicola

Sorry for the delay in following up

I have written a function which converts the date into UK format. When you pass the calendar's value to a variable you should pass the value as the USdate argument in the function

Public Function DateConverter(USDate As String) As Date



    Dim strMonth As String

    Dim strDay As String

    Dim strYear As String

    Dim strDate As String

    

    strDay = DatePart("d", USDate)

    strMonth = DatePart("m", USDate)

    strYear = DatePart("yyyy", USDate)

    

    strDate = strDay & "/" & strMonth & "/" & strYear

    

    DateConverter = CDate(strDate)

   



End Function