Login Page - Create Account

Support Board


Date/Time: Wed, 27 Nov 2024 06:33:58 +0000



Post From: Date/Time Format of exported data

[2019-08-10 20:02:34]
Bill Black - Posts: 6
It's when I try to combine the Date and Time fields so I can evaluate them in an algorithm. I think the .0 in the time field is causing the issues. When I trim that out I can combine the fields and I am off and running. I'd love to just generate Date and Time together in one field so I don't have to do the transformation after the export but I already have an ELT algorithm built overnight so it's not a burning issue for me at the moment. However, if there was a way to configure the time output format, that would be cool.