cannot join datetime value based on spesific time

yonhantdaenta89@hotmail.com

hi Expert,

I cannot create a value for datetime3 based on this code



date3 := DT2DATE("Somedate");
time3 := 150000T;
datetime3 := CREATEDATETIME(date3,time3);

I need to set a specific somedate to 3PM

the error says that the date was invalid

any ideas ?

thanks,

Sowkarthika

Hi,

For DT2DATE you should pass DateTime as parameter.

Date3 := DT2DATE(CURRENTDATETIME)
CREATEDATETIME(Date3,150000T)

Sowkarthika

Hi,

For DT2DATE you should pass DateTime as parameter.

Date3 := DT2DATE(CURRENTDATETIME)
CREATEDATETIME(Date3,150000T)

yonhantdaenta89@hotmail.com

Sowkarthika wrote: »

Hi,

For DT2DATE you should pass DateTime as parameter.

Date3 := DT2DATE(CURRENTDATETIME)
CREATEDATETIME(Date3,150000T)

still cannot work. that "somedate" was a datetime value

mohana_cse06

your somedate seems to be blank
assign value to it before using in DT2DATE

pavithrap0992

Hi,

Check if the Date parameter that you are passing to the CREATEDATETIME function is valid.

yonhantdaenta89@hotmail.com

Hi @Sowkarthika : your ansewer correct.

thanks,