Date Combo

[akpofureenughwu]

Good day everyone, I have three csv docs with dates, and I need all these documents to synchronise in terms of dates (same page with dates).

[sunny_talwar]

Two of the files have start and end date and orders just have a single date. How do you want to link all the stuff?

[akpofureenughwu]

Sunny.. Thanks for that observation, Can u link just the request and booking start and end date? Or do u have a better suggestions?

[sunny_talwar · Accepted solution]

The script can be improved, but see if this looks like it is going in the right direction

[akpofureenughwu]

Thanks Sunny but is it possible to remove out every year except 2016?

I usually use the Where statement

where year(date(date#) .............................. <>'1916' and so on...

What line of code will you use?

[sunny_talwar]

I modified the script to remove all years 2016. Again there are a lot of synthetic keys which doesn't make this a good model to proceed with, but you can start to make improvements by removing synthetic keys here.

[akpofureenughwu]

Hey bro.. Thanks for the effort. I tried locate the qvw you attached but it didn't respond.

I only need year 2016 in the year list.  Thanks Sunny

[sunny_talwar]

It didn't respond??? Not sure I understand what is wrong