How to feed the date into calendar?

Help
1

Hi, In my excel my date format is as shows in image
image

And my calendar date format is
image

So, how to do it, to change the format and click on calnder and select the date, please help me

2 Likes
2

Buddy were you able to type the date format here if so try this buddy
in_date_value = “15/09/2019”
out_date_value = Datetime.Parseexact(in_date_value.ToString,“MMM dd,yyyy”, System.Globalization.CultureInfo.InvariantCulture)

Cheers buddy @balkishan

1 Like
3

You can use dynamic selectors for this one :slight_smile:

2 Likes
4

Not getting can you explain me more bro. As I have a date value let…I am writing in the way

row(“Date”).ToString
Now please tell me what to do?
Because when I click on date field so calender is open

5

Acc to your method bro, here I am assigning to a string variable but in the left side it give me the error, can you tell me what is this?

image
image1353×98 6.64 KB

1 Like
6

remove that .ToString buddy @balkishan

1 Like
7

can you see bro…

image
image978×195 12.9 KB

8

Thats CultureInfo, use missed “o” buddy @balkishan
Sorry just now i updated, sorry for that…

1 Like
9

No issue bro, I corrected that, But can you see it showing me type error

image
image761×193 6.56 KB

As inDate & OutDate both I have taken string type.

10

Fine buddy at last to the datetime.parseexact
add like .ToString(“dd/MM/yyyy”)
or the date format you want to enter there in the calender
but one thing is it possible to enter the date value using type into activity in the calender, is that possible buddy…?

Cheers @balkishan

11

you means like this bro, plz correct me

image
image997×139 7.05 KB

Datetime.Parseexact.ToString(“dd/MM/yyyy”)( inDate,“MMM dd,yyyy”, System.Globalization.CultureInfo.InvariantCulture)

12

like ths buddy Datetime.Parseexact(“dd/MM/yyyy”)( inDate,“MMM dd,yyyy”, System.Globalization.CultureInfo.InvariantCulture).ToString(“dateformateyouwat”)

13

Yes, we can type date value in the calender

2 Likes
14

amazing then this would work buddy for sure

15

It seems something wrong.

image
image1191×282 18.9 KB

1 Like
16

buddy @balkishan

tostring atlast

like this

Datetime.Parseexact(“dd/MM/yyyy”)( inDate,“MMM dd,yyyy”, System.Globalization.CultureInfo.InvariantCulture).ToString(“dateformateyouwat”)

and one more thing buddy @balkishan
is inDate is of this format “MMM dd,yyyy”

17

No, bro, inDate in the format is
image

Like dd/mm/yyyy

2 Likes
18

I just sent you a zip file :slight_smile:

1 Like
19

BUDDY @balkishan then you must use this buddy
Datetime.Parseexact(“dd/MM/yyyy”)( inDate,“dd/MM/yyyy”, System.Globalization.CultureInfo.InvariantCulture) .ToString(“dateformateyouwat”)

XXXXXXXX
not this
Datetime.Parseexac t(“dd/MM/yyyy”)( inDate,“MMM dd,yyyy”, System.Globalization.CultureInfo.InvariantCulture) .ToString(“dateformateyouwat”)

1 Like
20

Did that work buddy
@balkishan