September 25, 201510 yr I'm starting to use the Let Function and need a bit of assistance please. I'm creating a variable based on the results of an ExecuteSQL(). It is returning the date from a table (so it can be used later) based on criteria selected by the user. The date in the table is stored as a date field as dd/mm/yyyy. However, when the query returns the date field and populates the variable its bringing it back as yyyy-mm-dd As a result when I want to use it further down I'm not getting any results. is there a way I can get the query to return the date as dd/mm/yyyy or convert it to this format to use later? TIA
September 25, 201510 yr http://www.seedcode.com/executesql-date-formats/ https://www.briandunning.com/cf/958 http://www.fmfunctions.com/functions_display_record.php?functionId=333 Google is your friend Edited September 25, 201510 yr by Kris M
Create an account or sign in to comment