petehepple
New member
- Local time
- Today, 17:58
- Joined
- Apr 19, 2012
- Messages
- 2
Hi there,
Hope you can help me with what (I hope) is a relatively straightforward macro. I have a table in a shared database that contains a date field (dd/mm/yyyy). For reporting purposes, we need each date to begin 01 (i.e., 01/03/2012), but our users sometimes forget and enter the actual day of the month instead (24/03/2012). I'm a bit of an enthusiastic amateur when it comes to things like this, and didn't get very far with this myself - is it possible to create a macro that would simply replace the first two numbers of each record in a column with "01"?
Thanks,
Pete
Hope you can help me with what (I hope) is a relatively straightforward macro. I have a table in a shared database that contains a date field (dd/mm/yyyy). For reporting purposes, we need each date to begin 01 (i.e., 01/03/2012), but our users sometimes forget and enter the actual day of the month instead (24/03/2012). I'm a bit of an enthusiastic amateur when it comes to things like this, and didn't get very far with this myself - is it possible to create a macro that would simply replace the first two numbers of each record in a column with "01"?
Thanks,
Pete