Date validation Where Variable represents Date

[PelicanProductions]

Hello, I am building a subscription database for a quarterly publication and need to be able to identify records for expiring subscribers. The database contains a field for ending issue but the issue is identified by season and year ie. "Summer 2007". How can I specify that "Summer 2007" equals a specific date or date range without renaming the values in the field? I am trying to create a script that will identify only expiring records. Please help if you can, I am a graphic artist & web designer by trade and this database stuff is new to me.

[mr_vodka]

See if this can help you.

Report ranges sample

[comment]

How can I specify that "Summer 2007" equals a specific date or date range without renaming the values in the field?

By defining a calculation field that translates it into a date or date range. For example:

Let ( [

m = Position ( "SprSumAutWin" ; Left ( EndIssue ; 3 ) ; 1 ; 1 ) + 2 ;

y = RightWords ( EndIssue ; 1 )

] ;

Date ( m ; 1 ; y )

)

This returns:

"Spring YYYY" - March 1, YYYY;

"Summer YYYY" - June 1, YYYY;

"Autumn YYYY" - September 1, YYYY;

"Winter YYYY" - December 1, YYYY;