Page tree
Skip to end of metadata
Go to start of metadata

Question

How can I isolate the first and last days of Per Diem travel?

Solution

When users select the MIE Per Diem expense type and use the checkboxes for 'First Day' or 'Last Day' of travel, these dates can be picked up in the Expense export with the following logic:

IF(LINE_ITEM_WIZARD_DETAIL CONTAINS "First Day of Travel") {CONCAT("First Day of Travel - " + DATE(LINE_ITEM_DATE,"dd-MM-yy"))} ELSE {IF(LINE_ITEM_WIZARD_DETAIL CONTAINS "Last Day of Travel") {CONCAT("Last Day of Travel - " + DATE(LINE_ITEM_DATE,"dd-MM-yy"))} ELSE {CONCAT("Continuous Travel- " + DATE(LINE_ITEM_DATE,"dd-MM-yy"))}}

 

Additional Information

Help Docs - Export Expressions