convert long to date in VBScript

[Alex Maier]

Hello,

I want to get the coordinates of the cursor in via Cursor.X1 in the VIEW module. because I need a date/time variant I would like how to convert the long value I get from the method to a Date/Time variant. In the coordinate window the display is in datetime, too, when the axis is a type of time-axis.
If I get a string representation of the long value then it would be possible to convert via CDate, but I don't even get a string. How can I do that?

Thanks,
Alexander Maier

[Ken_Tobler]

Hello!

You can convert the Cursor position to a String and then to Date Variant:

MyTime = CDate(Str(View.ActiveSheet.Cursor.X1,"#hh.nn.ss"))

Best regards

Ken