Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
how to convert
20131022005811 to 22/10/2013 |
Hi,
Check these in Text objects
=Date(Date#('20131022005811' ,'YYYYMMDDhhmmss'),'DD/MM/YYYY')
or
=Date(Date#(Left('20131022005811',8),'YYYYMMDD'),'DD/MM/YYYY')
If works then use as is in script by replacing with your field without single quotes.
Try like:
Date(Date#('20131022005811' , 'YYYYMMDDhhmmss') , 'DD/MM/YYYY')
Now you can replace your value with field name as well.
its not working..
i have a date field in this format(YYYYMMDDhhmmss)and i want to map this to calender function i'm using in which date is in format of DD/MM/YYYY.
How are you writing the code?
Date( Date#('YourField','YYYYMMDDhhMMss'),'DD/MM/YYYY')
Before u give Date format check what format its already defined in set format
Date( Date#('CDAT','YYYYMMDDhhMMss'),'DD/MM/YYYY')as Date,
in set format format defined is SET DateFormat='M/D/YYYY';
Use this
Date(Date#(CDAT,'YYYYMMDDhhmmss'),'DD/MM/YYYY') as Date
in set format change the date format MM/DD/YYYY and use this
Date( Date#(YourField,'YYYYMMDDhhMMss'),'DD/MM/YYYY')
this function is not working
i think this can be the problem dat i have defined date in calender function as dd/mm/yyyy and in defult set format this is M/D/YYYY'