Date Format And Regional Settings

    I use following to show date and time, currently it shows me month in Hebrew, because my "Regional Setting" are defined to Hebrew.

    Code
    Format(Date, "Long Date") & ", " & Time


    How to show it in English, without change in "Regional Setting"?

    Re: Date Format And Regional Settings


    Perhaps thiw works:


    Code
    Format(Date, "DD/MM/YYYY") & ", " & Time


    or this


    Code
    "[B][COLOR="Red"]'[/COLOR][/B]" & Format(Date, "DD/MM/YYYY") & ", " & Time

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!

Register Yourself Login