transform date value

39 views
Skip to first unread message

Pierre Larde

unread,
Apr 12, 2017, 3:49:53 PM4/12/17
to Lucee
The date value is like : oct. 6, 2016  (this is a silly french format)
how to convert this to an understandable date to put in a query.
Thanks for suggestion.

(does work automatically with ColdFusion/Access, not with Lucee/Ucanaccess)

Pierre.

W. Williams

unread,
Jun 20, 2017, 3:18:43 PM6/20/17
to Lucee
Hey Pierre!  Did you try to just do a DateFormat?  Try doing:

#DateFormat( Now(), "DD/MM/YYYY" )#
Reply all
Reply to author
Forward
0 new messages