Jan 13, 2011; 12:33
Andreas Carlsson
Validate if a date is date?
As usual, I'm sure I have seen a function for this but - as usual - I can't find it... :-P
I am entering different values in a text field. If the value is a real date I would like to know it.
Lets say I enter "2011-01-13" (which is the swedish system format for a date) I know this is a correct date, but how does FM know?
Please note tha any numerical value that is not a date (eg "13") is not a date in this case (even though I'm aware that its date value is "0001-01-13").
If( GetAsDate(Value) = A real date; "YES!"; "NO")
Any ideas?
#############################################################
This message is sent to you because you are subscribed to
the mailing list <fmpro@lists.lassosoft.com>.
To unsubscribe, E-mail to: <fmpro-off@lists.lassosoft.com>
To switch to the DIGEST mode, E-mail to <fmpro-digest@lists.lassosoft.com>
To switch to the INDEX mode, E-mail to <fmpro-index@lists.lassosoft.com>
Send administrative queries to <fmpro-request@lists.lassosoft.com>
Jan 13, 2011; 12:41
Andreas Carlsson
Re: Validate if a date is date?