Date/Time: inconsistent formats in a Date field
-
Attached file deals with issue of inconsistent date formats in a single field, where few extra steps are needed to bring all the values to the same format, including use of TEXTTODATE formula.
Another useful example :
4/18/2015 1:31:09.000000 AM
translates into Omniscope format
M/d/yyyy h:mm:ss.SSS aAttachmentsInconsistentDate.JPG 215K 
InconsistentDateField.iok 11K
Welcome!
It looks like you're new here. If you want to get involved, click one of these buttons!
Categories
- All Discussions2,595
- General680
- Blog126
- Support1,177
- Ideas527
- Demos11
- Power tips72
- 3.0 preview2
To send files privately to Visokio email support@visokio.com the files together with a brief description of the problem.