Fun with notes dates - @TextToTime, CDat, ZoneTime

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) :slight_smile: @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 :slight_smile:

Subject: Fun with notes - @TextToTime

Phew, it does the same thing with “red jello” as well. I was afraid it might discriminate!:slight_smile:

Subject: RE: Fun with notes dates - @TextToTime, CDat, ZoneTime

I suspect the setting “Strict date/time input” in the user preferences dialog might make Notes reject all colors of gelatin as time values.

Subject: RE: Fun with notes dates - @TextToTime, CDat, ZoneTime

It’s always so nice to read this forum AND be amused… :slight_smile: