How To Parse and Re Write A Date Field

**abrogard** · 07-08-2012, 06:44 PM

I have a Date Field and I would like to complete another field depending upon the contents of that date field.

In this way: if the Date is, say, 4/27/12 I want the other field to read: April 2012 and so on. Reading the month, putting it into words, reading the year, writing it out. This second field is NOT a date field.

Can anyone help?

**orange** · 07-08-2012, 07:05 PM

Review the Month, Year and Format functions.
http://www.techonthenet.com/access/f...ate/format.php

**abrogard** · 07-08-2012, 07:19 PM

Thank you very much. That'll fix it.

How To Parse and Re Write A Date Field

Thread Tools

How To Parse and Re Write A Date Field

Similar Threads

How to write an expression referring to two values from the same field

2 Tables - Parse Name Field in Table 1 and Find Value in Table 2

Convert single record into multiple records, parse memo field

How to write field values next to each other?

Parse a File from a Directory and write data to table

Posting Permissions