Hi,
I have a field titled startDate of data type DATE and has an input mask of 0000-00-00.
What I would like to do is store a date as mm/yyyy (08/2007).
How can I do this?
Storing date as m/Y
Moderator: General Moderators
- aceconcepts
- DevNet Resident
- Posts: 1424
- Joined: Mon Feb 06, 2006 11:26 am
- Location: London
- superdezign
- DevNet Master
- Posts: 4135
- Joined: Sat Jan 20, 2007 11:06 pm
For things like credit card expiry dates where there's only a month and year I store them as a date field, but always insert them as the first of the month the user entered. For example, if the user updates their card to expire on 08/2010 it goes into the database as 2010-08-01. It's not ideal, but it works.
- aceconcepts
- DevNet Resident
- Posts: 1424
- Joined: Mon Feb 06, 2006 11:26 am
- Location: London