Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Use below in script
Date(Date#(YourDateField,'DD. MMMM YYYY'), 'DDMMMMYYYY') as YourDateField
or
below in front end
Date(Date#(YourDateField,'DD. MMMM YYYY'), 'DDMMMMYYYY')
Use below in script
Date(Date#(YourDateField,'DD. MMMM YYYY'), 'DDMMMMYYYY') as YourDateField
or
below in front end
Date(Date#(YourDateField,'DD. MMMM YYYY'), 'DDMMMMYYYY')
or use this
Date(Date#(subfield (@5 ,'.' , 1) & '/' & PURGECHAR( @5, '. 1234567890') & '/' & SubField(@5,' ',-1),'DD/MMMM/YYYY'),'DD/MMM/YYYY') as DateInv
Thanks Manish
Very simple. Strange I'm sure I tried this but it didn't work.