Entering a date in the form dd/mm/yyyy

[Tinkerz]

Send("{UP}{UP}{UP}{UP}{CTRLDOWN}b{CTRLUP}{TAB}{TAB}{PGUP}{DOWN}{DOWN}{DOWN}{DOWN}{DOWN}{DOWN}{DOWN}{DOWN}{DOWN}{DOWN}{DOWN}{DOWN}{DOWN}{DOWN}{DOWN}{DOWN}{TAB}??????????{TAB}{TAB}{CTRLDOWN}b{CTRLUP}{ENTER}")

I am trying to do 2 things, but getting nowhere, firstly can autoit replace the ????? in the above script to the current day in the form dd/mm/yyyy

And then when I tab to another entry box not defined in the above script, do a calculation current date - 365 days?

Thanks

Tinkerz

[GordonFreeman]

@MDAY & "/" & @MON & "/" & @YEAR

If You BR i can help in PT-BR (Private msg)

[Tinkerz]

Sorry I dont understand, what is BR and PT-BR

[water]

Which application do you try to automate? Couldn't you use ControlSend to send the data directly to the control?

[careca]

Tinkerz: He means if you talk in Portuguese from Brasil.

Check this:

#include <Date.au3>
_NowDate()

[Tinkerz]

Send("{UP}{UP}{UP}{UP}{CTRLDOWN}b{CTRLUP}{TAB}{TAB}{PGUP}{DOWN}{DOWN}{DOWN}{DOWN}{DOWN}{DOWN}{DOWN}{DOWN}{DOWN}{DOWN}{DOWN}{DOWN}{DOWN}{DOWN}{DOWN}{DOWN}{TAB}{TAB}_Datenow(){TAB}{CTRLDOWN}b{CTRLUP}{ENTER}")
 

@MDAY & "/" & @MON & "/" & @YEAR

 

I dont understand how to put this in send keys statement?

Could a statement also include @YEAR -1?

 

The box I want to enter the date in is a calender drop down box, so I think the keystokes need to be sepearated or pasted in.

 

 

The application is called Ninjatrader, a stock trading application.

 

Thanks

Tinkerz

[careca]

One thing you could do is group those together, link so:

Send("{UP 4}") 
Send("{DOWN 16}")

That way you avoid having 16 down's next to each other lol

Not sure about that @year -1, try and tell us what happened, if it doesn't work, put the value in a variable and then subtract the ones you want.

$y = @year -1

Btw, the send works by sending one thing on each line, so you send it like the rest,

Send("{UP 4}")
Send("{DOWN 16}")
Send("@MDAY & "/" & @MON & "/" & @YEAR")

[water]

To create reliable scripts I suggest to drop the Send commands and use ControlSend.

Have you used the AutoIt Window Info tool to get the ControlId where you ned to enter the date?

[Tinkerz]

Is there a StringtoInteger command, I see alot in help but not this one.

I want this for the converstion $y = @year -1, it looks like @year is a string type, I want to turn to an integer and then back to a string.

Also is the _WinWaitActivate("Control Center - AAA1Turo1Intraday","")

is not true, I dont understand the help statement

Success: Returns handle to the requested window.

 

Control Center - AAA1Turo1Intraday this is the handle?

or

"Control Center - AAA1Turo1Intraday" this

Thanks

Tinkerz

[guinness]

Is there a StringtoInteger command, I see alot in help but not this one.

Int or Number.

[water]

To subtract values from a date/time use function _DateAdd with a negative value.

[Tinkerz]

I am trying the line

Send("@MDAY & "/" & @MON & "/" & @YEAR")

And In the box I get -1.IND

I Also tryed

$y =String((Number(@year) -1))

Send("@MDAY & "/" & @MON & "/" & $y")

But still the error -1.IND

I dont know how to put _DateAdd in the code

I presume

Local $sNewDate = _DateAdd('d', -365, _NowCalcDate())

But the format in help is yyyy/mm/dd I would like dd/mm/yyy

[GordonFreeman]

please use the code resource  to post code

Wrong:

Send("@MDAY & "/" & @MON & "/" & @YEAR")

Right:

Send(@MDAY & "/" & @MON & "/" & @YEAR)

And try it in -365 calculation:

#include <Date.au3>

$DATE = _DateAdd("y",-1,_NowCalcDate())
$YYYY = StringMid($DATE,1,4)
$MM = StringMid($DATE,6,2)
$DD = StringMid($DATE,9,2)
$DATE = $DD & "/" & $MM & "/" & $YYYY

MsgBox(0,"",$DATE)

Edited May 26, 2013 by GordonFreeman

[somdcomputerguy]

MsgBox(0, "", @YEAR & " : " & @YEAR - 1)

[careca]

Also is the _WinWaitActivate("Control Center - AAA1Turo1Intraday","")

is not true, I dont understand the help statement

 

Its "WinWaitActive" not "_WinWaitActivate"

[Tinkerz]

_WinWaitActivate("Message","")
Send("{ENTER}")
Sleep(5000)
_WinWaitActivate("Control Center - AAA1Turo1Intraday","")

Func _Au3RecordSetup()
Opt('WinWaitDelay',100)
Opt('WinDetectHiddenText',1)
Opt('MouseCoordMode',0)
EndFunc

Func _WinWaitActivate($title,$text,$timeout=0)
    WinWait($title,$text,$timeout)
    If Not WinActive($title,$text) Then WinActivate($title,$text)
    WinWaitActive($title,$text,$timeout)
EndFunc

_AU3RecordSetup()

_WinWaitActivate("Message","")

_WinWaitActivate("Control Center - AAA1Turo1Intraday","")

I am using the autorecorder to start as the basis of my scripts, thats why the _ appears.

What does the handle return if its not a message or Control Center - AAA1Turo1Intraday, so I can run an if statement on another set of keystrokes if this does not appear

Thanks again

Tinkerz

[water]

I dont know how to put _DateAdd in the code

 

I presume

Local $sNewDate = _DateAdd('d', -365, _NowCalcDate())

But the format in help is yyyy/mm/dd I would like dd/mm/yyy

You have to translate the date to yyyy/mm/dd format. _DateAdd supports a lot of separators but expects the yyyy mm dd format.

[guinness]

#include <Constants.au3>
#include <Date.au3>

; Convert yyyymmdd to ddmmyyyy or yyyy-mm-dd to dd-mm-yyyy or yyyy/mm/dd to dd/mm/yyyy.
MsgBox($MB_SYSTEMMODAL, '', StringRegExpReplace(_NowDate(), '^(\d{4})\D?(\d{2})\D?(\d{2})$', '\3/\2/\1'))