Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Can I Change char field to year field
- Thread starter davefm1
- Start date
synapsevampire
Programmer
You have a few options here:
val(right(01 Jan 02,2))+2000 will return 2002, which is suitable for years beyond 1999, but I would suggest that you convert the text to a formula containing a date:
// @MyDate
cdate({MyTable.MyDateField})
Now use this formula to group by (you can set groups on dates to be by the year using the The Section Will Be Printed set to for each year in the grouping dialog).
-k kai@informeddatadecisions.com
val(right(01 Jan 02,2))+2000 will return 2002, which is suitable for years beyond 1999, but I would suggest that you convert the text to a formula containing a date:
// @MyDate
cdate({MyTable.MyDateField})
Now use this formula to group by (you can set groups on dates to be by the year using the The Section Will Be Printed set to for each year in the grouping dialog).
-k kai@informeddatadecisions.com
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question