LAE

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: HHamilton

Hi,

I have to cat 2 data sources, but in one I have datetime, and in the other date. How do I convert date to datetime? I don't care what the timestamp is on the one I am changing into a datetime.

Thanks,
Heather

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: ryeh

Hi, Heather. You can use the 'timestamp' function. Something like:

node:Convert_to_DateTIme
bretype:core::Filter
editor:Label=Convert to DateTIme
editor:sortkey=557efea51ef16db7
input:@40fd2c74167f1ca2/=Static_Data_3.40fe6c55598828e5
output:@40fd2c7420761db6/=
prop:Script=<<EOX
newDate = timestamp(Date,time(0,0,0))
emit *,newDate

EOX
editor:XY=690,310
end:Convert_to_DateTIme

node:Static_Data_3
bretype:core::Static Data
editor:sortkey=557efe9134a707df
output:@40fe6c55598828e5/=
prop:StaticData=<<EOX
Date:date
2015-01-01
EOX
editor:XY=550,310
end:Static_Data_3

Note: This was originally posted by an inactive account. Content was preserved by moving under an admin account.

Originally posted by: HHamilton

Thanks...figured it out finally after I posted