I have a SubQuery (SubQuery1.Value) that produces the string 'Windows 10 Enterprise v1903', however I only want 1903 to show in the report.SubQuery1.Value As ImageAny assistance would be appreciated!
I am reporting on a registry value that produces a time stamp that looks like '20181025162152.000000-420'. I simply want to convert this to a short date that Excel can read. Using the example time stamp above it should look like '10/25/2018'.I was ...
Thanks again for your reply! I am not sure why this isnt working for me. When I try:Convert(Date,Left(SubQuery2.Value, 8)) As [Deploy Date 2],I get the error: The specified data type is not valid. [ Data type (if known) = Date ]When I try:Convert(D...
Also tried:Convert(DateTime,Left('SubQuery2.Value', 8)) As [Deploy Date 2],and got the error: [ Token line number = 1,Token line offset = 632,Token in error = Left ]
I apologize for my ignorance. I tried:Convert(Date,Left('SubQuery2.Value', 8)) As [Deploy Date 2],And received the error 'The specified data type is not valid. [ Data type (if known) = Date ]'RC62N wrote:If all you want is the date and you're certai...