topic date in a script in QlikView

date in a script

rcandeo — Sat, 08 Aug 2009 02:30:40 GMT

How can I get a formated date (DD/MM/YY) using VB Script?

date in a script

Sat, 08 Aug 2009 02:50:13 GMT

suppose you have the date and time in this format

20050718095318.019149-420 then you can use the below code to convert into

7/18/2005 9:53:18 AM

CDate(Mid(dtmStart, 5, 2) & "/" & _
Mid(dtmStart, 7, 2) & "/" & Left(dtmStart, 4) _
& " " & Mid (dtmStart, 9, 2) & ":" & _
Mid(dtmStart, 11, 2) & ":" & Mid(dtmStart, _
13, 2))

Hope this helps

Talha

date in a script

rcandeo — Sat, 08 Aug 2009 03:01:02 GMT

Look my script, it didn't work:

ActiveDocument.GetVariable("Date").setContent ActiveDocument.Evaluate("today()"),false

ActiveDocument.GetField("Payment_Date").Select ActiveDocument.Evaluate(Mid(Date,1,6)&Mid(Date,9,2))

The result of the Date variable is 07/08/2009

I need Payment_Date field to stay like this: 07/08/09 but is not working

date in a script

Tue, 11 Aug 2009 01:28:20 GMT

Hello

attached is the application i tried and it is working for me,please have a look and let me know

Talha

date in a script

rcandeo — Tue, 11 Aug 2009 02:52:29 GMT

it worked, thank you

date in a script

rcandeo — Tue, 11 Aug 2009 02:54:05 GMT

it worked. Thank you very much.