Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have "Completion Date" field which looks like this
7/17/2019 09:06 AM America/New York
I managed to separate date from the text but cannot convert date into date datatype.
Can someone help?
PS - Sorry for the format. Somehow it doesn't allow me to post as is.
text to date can be achieved by date#
date#(textfield, 'format in which text stores date for ex 12/01/2019 could be dd/mm/yyyy')
@yashkoradia Could you please share an sample on how your Completion Date could look like
I think you left that part out in your original post.
Hi,
probably this could work:
Subfield(data,' ',1) & ' ' & Subfield(data, ' ',2) & ' ' & Subfield(data, ' ',3) ---> 7/17/2019 09:06 AM
Subfield(data,' ',1) & ' ' & Subfield(data, ' ',2) ---> 7/17/2019 09:06
Subfield(data,' ',1) ---> 7/17/2019
on top of what @StarinieriG suggested , my guess is you will have to add date# if you want field of date type
something like this
date#(Subfield(data,' ',1) ,'mm/dd/yyyy') , this will generare date number, add this to format it as date
date(date#(Subfield(data,' ',1) ,'mm/dd/yyyy') ,mm/dd/yyyy')