Let Function

[aguest]

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

 

[Kris M]

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, 2015 by Kris M

[Lee Smith]

Google is your friend

+1