How to use the first of two dates

[Anonymous]

I have two dates of receipt for material. I use Concat to get them both to show in the field. However, I need to do my calculations using just the first date.

First I have -[Confirmation Date] gives me one date (Ex. 2015-09-15)

Then =Concat (DISTINCT [Posting Date],' / ')   gives me two dates (Ex. 2015-09-15 / 2015-09-21)

In the third column I need to subtract the first of the two posting dates from the confirmation date.

How would I write this?

[kiranmanoharrode]

Hello James,

= Ceil(Num([Posting Date]) - Num([Confirmation Date]))

It will give you the output in No. of days.

Regards,

Kiran

[#3]

If I understand, you are looking for the number of days between the posting date and confiramtion date?

In the above example you want to subtract 2015-09-15 - 2015-09-21 or is it the other way around?

You are building the concatenated fied based on the 2 individual fields so you should be able to subtract ehe indivdula fields (see Kiran response)

[Anonymous]

Thanks for the quick reply, but it still did not work. I still get a null in the on time,

[maxgro · Accepted solution]

may be

min([Posting Date] - [Confirmation Date])

[pamaxeed]

Hi,

to get the first Posting Date use subfield([Posting Date], '/', 1)

so try something like that:

date(subfield(Concat (DISTINCT [Posting Date],' / ') , '/', 1), 'YYYY-MM-DD') - [Confirmation Date]

Patric

[Anonymous]

That Got it. Thank you very much.

[MarcoWedel]

please post sample data/application to demonstrate with.

regards

Marco