Concatenation

[donlste]

Hi there,

Can anyone help me on how I go about concatenating a Date and a Time field.

I know it's not possible through the usual concatenate command.

If anyone can help me, that would be fantastic.

Ta

 

[promero]

At universe level (DB2 databases):
[tt]TIMESTAMP(Date, Time)[/tt]

At Report level:
[tt]=AsDate(FormatDate(<Date>,&quot;d/m/yyyy&quot & FormatDate(<Time>,&quot; H:m:s&quot, &quot;d/m/yyyy H:m:s&quot[/tt]

 

[surthinks]

i have created two variables to test ur problem named
today'sdate and today's time.

=FormatDate(<today'sdate> ,&quot;dd/mm/yyyy&quot &quot; &quot;& ,<today'stime>)

after that i h've utilised ampersand to concatenate, for better readbility use double quotes with two spaces.

 

[surthinks]

prev message i think the formula is not clear

FormatDate(<today'sdate> ,&quot;dd/mm/yyyy&quot& &quot; &quot;& <today'stime>

rgds,
Suresh