Sage 100

Sage 100 2013, Advanced VI Export of SO Details - the ""updated date"" and ""updated time"" aren't available in SO_SalesOrderDetails/Header export layouts. I'd like to use this to filter the exported records. Do I need to alter the dictionary to see these fields? Second part, when/if I can get to these fields, I'd like to set a conditional selection to select records based on Today. I don't see a function that will allow me to select ""Today"".

Click on the Options button on the Header tab of Export Job Maintenance and choose Display Read Only Fields for Export. I can see the date and time updated fields then.

Looks like the date is considered a String to VI, so not date functions would be available on it unless there is a function to change a string to a date...

That's it! Thanks @BethBowers. Now for converting current date to string and testing the result for filtering. Any ideas anyone?

Okay this is odd, Select Tab, DateUpdated with Less Than or Equal =DTE() in the selection value returns records but when changed to DateUpdated Equal =DTE() or DateUpdated Greater Than Equal =DTE() returns nothing.

Eureka! I found an answer for this (of coarse starting in this site) that lead to a SageCity bit. I did a write up with screen shots and attached for reference. Change the Date Mask on the date you are comparing in the data tab to: YMD and remove anything in the SEP fields Next on the Select Tab, select the same date field and in the selection value enter: EVS(""DTE(0:""""YYYYMMDD"""")"")