Jerry_B - profile

Jerry_B · Apr 26, 2022

I have a Google Sheet with 3 separate columns for Day Year and month … and I would like to instead enter a Date field …It’s a simple table I’m moving to Airtable because it’s more user friendly IMO. … iut’s for about 2000 records. See the picture att...

Jerry_B · Apr 26, 2022

In my base I have a field for Date … When I used your formula , the times are correct but It populates Today’s date … I’m assuming that’s because of the “NOW” wording in your formula … I changed the now to “Date” to call in the date that’s already in...

Jerry_B · Apr 26, 2022

I figured it out. . there is a checkbox to not include time… thanks for all your help

Jerry_B · Apr 26, 2022

I’m almost there … I first use concanate formula to string the text together and then I used Date time parse the following formulat DATETIME_PARSE({Text}, ‘M/D/YYYY’) It worked except that it displays the time as 12:00am … is there an edit I can do t...

Jerry_B · Apr 26, 2022

I’ll check it out… . FYI … I tried this CONCATENATE(Month,Day,Year) but it didn’t quite work out …

User Statistics

User Activity

Is there a formula to combine 3 separate columns for "day" "Month" "year' .. into one Date field

Re: Time (without date) field option

Re: Is there a formula to combine 3 separate columns for "day" "Month" "year' .. into one Date field

Re: Is there a formula to combine 3 separate columns for "day" "Month" "year' .. into one Date field

Re: Is there a formula to combine 3 separate columns for "day" "Month" "year' .. into one Date field