Entering Date into Calendar

Help
1

Hi all,

First post here so hopefully this is in the right place! Forgive me if not.

I’m struggling to enter a date (collected from a SQL Database into a Data Table in UI Path) into a specific UI Element within our accounting software.

After countless google searches I’m still not any closer to resolving this.

Type Into Activity
image

I’ve double checked that the correct element is being selected in the below activity, and it does highlight the first two digits of the inception date (“03” in this example). However, when it then moves onto the type into activity nothing is entered and it moves onto the next task. I’ve checked manually and when I type on my keyboard the following “16-03-2019” it successfully enters the date.

Do I need to have multiple “hotkey” activities with the correct key being selected based on what i want to enter if the type into activity isnt working?

Regards,
Jack

2

Hi @JackBethell,

Welcome to UiPath Community.

Please try in Type Into row(“EffectiveDate”).ToString("dd-MM-yyyy)

Regards
Vishnu

3

Hi @winningvish

Thankyou for the swift reply! Much appreciated.

I’ve done the formatting in my T-SQL query already so it is returned as below. However, I will give your suggestion a try and let you know if it helps.

image

Thanks again.
Jack

1 Like
4

image

Unfortunately it came up with this error? Any ideas @winningvish

5

@JackBethell Try this
assign str = row(“EffectiveDate”).ToString
assign str = cDate(str).ToString(“dd-MM-yyyy”)

6

unfortunately this didn’t work either, thank you for your reply though!

I have also just tried:

Convert.ToDateTime(row(“EffectiveDate”)).ToString(“dd-MM-yyyy”)

7

Hi @JackBethell,

before typing the row(“EffectiveDate”) value into Type into, please use the Log Message activity and see how the value is printed in Output panel.

log

Regards
Vishnu

8

It came out as follows image

9

That’s great. This is how you want to type in that Date Field right?

if yes, just use row(“EffectiveDate”).tostring

In Type into Property, please check Click Before Typing and Check Empty Field

Please let me know if it works.

Regards,
Vishnu

10

Heres the full sequence of what I’m doing that still isn’t working, note you have to “tick” the text box to make it editable and then i am using “Click Text” to select the day that is within that box before i begin typing. By checking “Click Before Typing” it is deselecting the text box - so i can’t use that option. Empty field is selected but it still doesn’t work.

image