topic Re: How do I add two different dates into one date field in App Development

How do I add two different dates into one date field

Sat, 04 Mar 2017 20:30:42 GMT

Here is my scenario I have two different Dates Sale Date and order Date these two dates in one table but these are two separate fields I want to have only one field like in this case I want to have only one date which is sales date i want order date to merge into that how do i do that

Re: How do I add two different dates into one date field

Sat, 04 Mar 2017 20:54:38 GMT

Could you write an example what logic do you want to use in the merging?

Re: How do I add two different dates into one date field

sunny_talwar — Sun, 05 Mar 2017 01:40:23 GMT

May be you need this?

Canonical Date

Re: How do I add two different dates into one date field

RSvebeck — Sun, 05 Mar 2017 20:28:42 GMT

1/ you create one master calendar that range from first date possible last date possible.

2/ add a calendar type field to that calendar and give a new field called "calendar type" the value "order"

3/ concatenate (duplicate) that calendar table, but without that field "calendar type" and add a new value to "calendar type", with the value "sales".

you now have 1 master calendar that works for both dates, just demand the user to always choose one of the two "date types"

brg

Robert Svebeck

Svebeck Consulting AB