Can a calc field be used in GetAsDate

[mentairia]

I have sent a sample of this and tried several hundred things I am at my wits end and need your help.

Thanks Tony D

Figurethis.zip

[LaRetta]

Hi mentairia,

I hope this was a sample file. It is confusing to name your fields the same as functions. I changed your Month field to Mo and I changed your Year field to Yr. Eliminate all your other calcs. Create ONE calc field (result is Date) with:

( 1 + Div ( ( Position ( "January__February__March____April____May______June_____July_____August___SeptemberOctober__November_December_"; Mo ; 1 ; 1 ) -1 ) ; 9 ) ) & "/" & 1 & "/" & Yr

The underlines are simply spacers to make the months all equal in length (9) then Position() converts them to the month number. I learned this trick from -Queue-!! And it's been a useful tool. You can copy/paste it into your calc box - just change the two field names to match yours.

LaRetta :wink2:

[mentairia]

Not sure where this Calc goes can you show me a sample?

Thanks and LOL Yes this is a sample File hehe

[LaRetta]

Here you go...

Oh. This calculation doesn't need to be unstored. I always test calcs unstored. Uncheck 'Unstored' in Options.

FigurethisREV.zip

Edited November 4, 2005 by Guest