topic Re: Convert to Date in App Development

Convert to Date

yashkoradia — Tue, 21 Dec 2021 21:30:18 GMT

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.

asinha1991 — Tue, 17 Sep 2019 16:34:58 GMT

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')

Vegar — Tue, 17 Sep 2019 16:42:56 GMT

@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.

StarinieriG — Wed, 18 Sep 2019 10:14:02 GMT

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

asinha1991 — Wed, 18 Sep 2019 10:49:11 GMT

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')