Jigna has attended:
Access Intermediate course
Changing data formats
Hi,
I need to change the way some date data is shown in access. It has been provided as a text field.
I currently have date ranges shown as yyyymm. I need to see it as 01/mm/dddd (currently have no "dd", therefore need to add a 01 at the beginning to get what I need).
Is there a way I can do this? Maybe in the input mask or expression build?
Thanks
Jigna
RE: Changing data formats
Dear Jigna
Thank you for attending Access Intermediate course. I hope that you enjoyed the course.
I am not sure if you mean to say that the field that the date appears on has got a Text data type in the design view.
Please ensure that field has Date/Time data type and then choose the short date from the Field properties at the bottom part of the design view of the table.
If you want the user to follow the specific format then simply type in 99/99/00;0 in the input mask box just below the format box.
Just for your information:
9 is for any digit or space which is not mandatory
0 is for digit and is manadatory
/ is the literal character that is normally used for separating days, months and years in a data/time format
;0 means that you want the literal character to be displayed in the filed when the user starts entering data. [b]If you leave it blank or use ;1 then the literal
