I am new to relevance language. could someone help to convert date format for below code
Q. preceding texts of last " " of preceding texts of last " " of (it as string) of (maximum of last write times of keys whose (name of it contains “.KB” or name of it contains “_KB” or name of it starts with “KB”) of keys( “HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall”;“HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Component Based Servicing\Packages”;“HKEY_LOCAL_MACHINE \Software\Microsoft\WindowsNT\CurrentVersion\Hotfix”) of (registry; native registry))
A. Tue, 14 Feb 2017
above code is working fine but I need output like 14/02/2017
If we first take the answer, and try to convert it to the desired date format as a working example, we might leverage something like the following:
(day_of_month of it as string & “/” & (month of it as integer as string) & “/” & year of it as string) of (“Tue, 14 Feb 2017” as date)
If you want the month format to be MM:
(day_of_month of it as string & “/” & (if (month of it as integer > 10) then (month of it as integer as string) else (“0” & month of it as integer as string)) & “/” & year of it as string) of (“Tue, 14 Feb 2017” as date)
Putting this together with your original relevance, you might get something like:
(day_of_month of it as string & “/” & (if (month of it as integer > 10) then (month of it as integer as string) else (“0” & month of it as integer as string)) & “/” & year of it as string) of ((preceding texts of last " " of preceding texts of last " " of (it as string) of (maximum of last write times of keys whose (name of it contains “.KB” or name of it contains “KB” or name of it starts with “KB”) of keys( "HKEYLOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Uninstall";"HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Windows\CurrentVersion\Component Based Servicing\Packages";“HKEY_LOCAL_MACHINE \Software\Microsoft\WindowsNT\CurrentVersion\Hotfix”) of (registry; native registry))) as date)