Try to get an invalid value out of @TextToTime Dim TempValue As Variant
Err = 0
On Error Resume Next
TempValue = Evaluate("@TextToTime(""green jello"")")
TempValue = TempValue(0)
On Error Goto 0
If (Err = 0) And (Datatype(TempValue) = 7)Then
Messagebox Cstr(TempValue)
Else
Messagebox "Invalid Date"
End If
Apparently “Green Jello” is equal to the time 12:00:00 AM (not a formula error)
@TextToTime must be really, really advanced!
Try to convert ‘daylight’ time-zones to a date using CDat.
CDat("January 1, 2000 12:00:00 AM PDT")
Try to retreive a lotusscript date for the “ZoneTime”
Dim v as Variant
Dim d as New NotesDateTime(Now) 'Why is it not documented that I can use LSDateTimes to initialize NotesDateTimes?
v = d.ZoneTime 'Where is LSZoneTime?? Is there NO way to retreive the "user entered" date as a LSDateTime?
v = cDat(d.ZoneTime) 'CRASH - ZoneTime uses PDT/etc which crashes CDat. Fallback? Use @TextToTime, which ALWAYS returns a date, even if you pass it the contents of an entire book in a string value.
Try to determine if a Time value or Date value is a wildcard (“AnyDate” or “AnyTime”). You cant, other than checking if the date is 1899-12-30. How do you check if it is an “AnyTime” value?
Open a document in a PST time zone that was entered in a EST time zone. Watch, amazingly, as the timezones are converted to PST even though those fields are not modified.
Try to store a time value where you don’t care about time zones (ie/ 12:00:00 AM should be 12:00:00 AM in EVERY time zone). The “Always show timezone” field property doesn’t count ![]()