Assign DateTime value directly to Date Time variable

Help StudioX
,
1

Hi,

Can any one tell me ,

Can we assign DateTime Value to Date Time Variable.
Like

sampleDateTime = “12/02/2020” in assign activity

sampleDateTime is of DateTime datatype.

Thanks in advance.

1 Like
2

@saritha

Try this.

           sampleDateTime = CDate(“12/02/2020”)
1 Like
3

dateTimeVariable= Datetime.ParseExact(sampleDateTime,“dd/MM/yyyy”,System.Globalization.CultureInfo.InvariantCulture)

1 Like
4

Thanks Lakshman,

My question is, does every value is taken as string ?

thanks in advacne

5

Hi @saritha ,

Ideally, you should ensure that the format is constant throught before converting the variables.

CDate and Convert.ToDateTime doesn’t work with all formats, which is why it is better to play it safe and use:

DateTime.ParseExact("12/02/2020", "dd/MM/yyyy", Nothing)

Kind Regards,
Ashwin A.K

1 Like
6

sampleDateTime = new datetime(2020, 02, 12)

This set’s the date properly, without any issue around dd/mm or mm/dd formats.
Then when you want to use it use .tostring(“dd/MM/yyyy”) or however you need it.