Date Format - within and outside MS Access

[arm1]

Hi,

I was wondering if anyone can help me.

I am trying to set the date format, but not of access dates. Rather, I am trying to set the date format of the users Regional Options date format, but from WITHIN MS Access.

The problem is, that users create entries... a (medium) date is obtained and entered within the record. However... if the user's regional settings read dates (for example) like m-d-y and I am entering dates as d-m-y then the date affixed to the record gets messed up.

I am open to other suggestions on how to resolve this... I just figured if I can set user computer date formats... then I don't need to worry that they would not be the same format.

Thanks,

- arm1

 

[irish634]

You can use the DatePart function to extract the m, d, and yyyy. Then you can put them together in any arrangement you want to. I think it will extract correctly regardless of the user's settings.

Not the best solution, but you can have the users have 3 different inputs. A separate drop down for month, day, and year. Then string it all together in the format you want.

Hi,

I was wondering if anyone can help me.

I am trying to set the date format, but not of access dates. Rather, I am trying to set the date format of the users Regional Options date format, but from WITHIN MS Access.

The problem is, that users create entries... a (medium) date is obtained and entered within the record. However... if the user's regional settings read dates (for example) like m-d-y and I am entering dates as d-m-y then the date affixed to the record gets messed up.

I am open to other suggestions on how to resolve this... I just figured if I can set user computer date formats... then I don't need to worry that they would not be the same format.

Thanks,

- arm1