Help with function to abbreviate a Date/Time field.

[accessmatt]

Hello,



I have Date/Time Field data like this:

9/22/2014 6:20:05 PM

. I'm trying to convert that into a field in my query so that the output would be this: 9/2014. Could anyone help with the formula?

Thanks,

[CJ_London]

what you are seeing is a formatted view of the value which will be something like 41904.7639467593. The value to the left of the dp represents the date, and the value to the right the time expressed as a percentage of the number of seconds in the day. To format as you want in a query for example try

format(myDate,"m/yyyy")

or in the control of a form or report, set the relevant control format property to m/yyyy

[pbaldy]

Try

Format(FieldName, "m/yyyy")