topic Convert months and days into date in App Development

Convert months and days into date

Fri, 01 Sep 2017 09:55:13 GMT

Hi guys,

i have 4 fields: minDay, minMonth, maxDay, maxMonth

i need to convert them into 2 fields: minDate and maxDate; so i have to join month and day in one field without the year.

I have already tried MAKEDATE but it also inserts the year (not correct!)

Can anyone help me?

Thanks,

Federica

antoniotiman — Fri, 01 Sep 2017 10:51:49 GMT

Hi Federica,

which are the formats of Dates ?

Fri, 01 Sep 2017 11:01:13 GMT

‌Numbers

jonathandienst — Fri, 01 Sep 2017 11:38:30 GMT

Well a date value always needs a year. But you could create a custom field like

=Date(Date#(minMonth & '-' & minDay, 'MM-DD'), 'DD-MM')

(if month is a number)

=Date(Date#(minMonth & '-' & minDay, 'MMM-DD'), 'DD-MM')

(if month is a month name abbreviation)

=Date(Date#(minMonth & '-' & minDay, 'MMMM-DD'), 'DD-MM')

(if month is a full month name)

Set the output format by replacing the last 'DD-MM' in the expression with your desired format.

antoniotiman — Fri, 01 Sep 2017 11:42:13 GMT

And the format of Min/MaxDate ? DDMM ?

Try like this

Date(MakeDate(2017,vMonth,vDay),'DDMM')

Anonymous — Fri, 22 Sep 2017 09:09:53 GMT

ok, useful, thanks