Matching Dates Alert

[AlanP]

Hopefully this is an easy fix!

END GOAL: Two separate date fields (one is imported) need to match. If match, the calc will say 'MATCH', if not it will be blank.

PROBLEM: The imported dates come from a SQL database from somewhere else and don't have a leading zero (0) for the month, whereas in filemaker it does include a leading 0 (e.g. 01 compared to 1)

CALC: This is what I have so far, and it works fine on 2 character months, but won't on the ones without leading 0's. Any ways to fix this issue?

  Case ( Imported_CertDate_MOPR   =   Training History::Training Date History;"MATCH" )

"Imported_CertDate_MOPR" is the imported dates that DO NOT have the leading 0's for 1 character months.

"Training Date History" is the FileMaker db dates that do have the leading 0's. I'd prefer not to muck with our data at all.

Thank you in advance!!

Edited July 9, 2010 by Guest

[Raybaudi]

Try:

Case ( GetAsDate ( Imported_CertDate_MOPR ) = Training History::Training Date History;"MATCH" )

[AlanP]

That worked perfectly! Thank you!!! :