InstalledOn Date Format

Content Authoring
1

I am trying to write relevance to bring back the InstalledOn value of a specific hotfix. However, I am having trouble trying to get the format of the output correct. The criteria is to bring back a value that will allow for proper sorting within BigFix.

I have two relevances:

Q: (( (it) ) of time value of property “InstalledOn” of select objects “* from Win32_QuickFixEngineering where HotFixID = ‘KB3116278’” of WMI) as string | “Not installed”
A: Fri, 25 Mar 2016 00:00:00 -0400
T: 1330.498 ms

Q: ((it) of string value of property “InstalledOn” of select objects “* from Win32_QuickFixEngineering where HotFixID = ‘KB3116278’” of WMI) | “Not installed”
A: 3/25/2016
T: 1587.144 ms

I am trying to get an output as YYYYMMDD so that it will do proper sorting within the console.

2

Hello – if you leave it as a time value it should be sortable in the console:

Q: time value of (property "InstalledOn" of select objects "* from Win32_QuickFixEngineering where HotFixID = 'KB3116278'" of WMI | error "Not installed")