topic Re: convert eg 21. January 2015 to a date in App Development

convert eg 21. January 2015 to a date

robert99 — Fri, 05 Feb 2016 10:46:28 GMT

The date is in this format

DD. MMMM YYYY

I converted using (@5 is the date field)

subfield (@5 ,'.' , 1) & '/' & NUM (MONTH (DATE#( PURGECHAR( @5, '. 1234567890'), 'MMM'))) & '/' & 2016 as DateInv

NB Its only 2016 dates for now

Why doesn't something like this work

Date# (@5 , 'DD. MMMM YYYY')

I tried everything I could think of but no joy

Including converting @5 to 21January2016 (using trim and purgechar etc) before using date#

Thanks for any help.

MK_QSL — Fri, 05 Feb 2016 10:48:26 GMT

Use below in script

Date(Date#(YourDateField,'DD. MMMM YYYY'), 'DDMMMMYYYY') as YourDateField

below in front end

Date(Date#(YourDateField,'DD. MMMM YYYY'), 'DDMMMMYYYY')

MK_QSL — Fri, 05 Feb 2016 10:56:43 GMT

or use this

Date(Date#(subfield (@5 ,'.' , 1) & '/' & PURGECHAR( @5, '. 1234567890') & '/' & SubField(@5,' ',-1),'DD/MMMM/YYYY'),'DD/MMM/YYYY') as DateInv

robert99 — Fri, 05 Feb 2016 11:05:40 GMT

Thanks Manish

Very simple. Strange I'm sure I tried this but it didn't work.