Help

 | CliFlo Home | close window
Search on keyword:  

Date/Time Formats in Main Query Form

The date/time fields in the data output can be in a range of formats as follows:

  1. Default (yyyymmdd:hhmi)
  2. Excel (d/m/yyyy hh:mi)
  3. Excel (d/m/yyyy hh)
  4. Excel (d/m/yyyy)
  5. Excel (d/m/yy hh:mi)
  6. Excel (d/m/yy hh)
  7. Excel (d/m/yy)
  8. Excel (d-Mon-yyyy hh:mi)
  9. Excel (d-Mon-yyyy hh)
  10. Excel (d-Mon-yyyy)
  11. Excel (d-Mon-yy hh:mi)
  12. Excel (d-Mon-yy hh)
  13. Excel (d-Mon-yy)
  14. CSV (yyyy,Mon,dd,hh,mi)
  15. CSV (yyyy,Mon,dd,hh)
  16. CSV (yyyy,mm,dd,hh,mi)
  17. CSV (yyyy,mm,dd,hh)
  18. CSV (yyyy,ddd,hh,mi)
  19. CSV (yyyy,ddd,hh)
  20. TAB (yyyy\t Mon\t dd\t hh\t mi)
  21. TAB (yyyy\t Mon\t dd\t hh)
  22. TAB (yyyy\t mm\t dd\t hh\t mi)
  23. TAB (yyyy\t mm\t dd\t hh)
  24. TAB (yyyy\t ddd\t hh\t mi)
  25. TAB (yyyy\t ddd\t hh)
  26. Space (yyyy Mon dd hh24 mi)
  27. Space (yyyy Mon dd hh)
  28. Space (yyyy Mon dd)
  29. Space (yyyy mm dd hh mi)
  30. Space (yyyy mm dd hh)
  31. Space (yyyy mm dd)
  32. Space (yyyy ddd hh mi)
  33. Space (yyyy ddd hh)
  34. Excel-US (m/d/yy hh:mi)

Note "\t" is a tab character (decimal 009, hex 09), "ddd" is day of year. "CSV" is comma delimited format.

See also: