Use Date Sequence in Query

[PoojaPatel]

Dear Friends,

I have attached example file, 1st tab include table format and 2nd tab for Query.

I will add all data in table format. i am getting problem in column number E "entry date" at Query tab.



please can you help me how to add date formula based on sequence as below in "entry date" column at Query tab.

12/08/2015 12:09:00 AM

12/02/2018 12:08:00 AM

11/10/2018 12:07:00 AM

[June7]

I don't understand what you are asking for.

You note 'two types of data' - what are the two types, Grocery and Baked Goods?

What's wrong with having replicated dates? I see the same date (12/08/2015) duplicated in the first highlighted group.

[PoojaPatel]

Yes, There are bit complex question here,

1st Tab there are sequence no in "column c". I want to use that sequence and put into descending order in to query,

Sequence no column in C at Query tab.

I have so many store name - Grocery, Baking Goods, Dairy products, Sea Food

This for Grocery.

When Sequence no 9 comes, 08/12/2015 (mm/dd/yyyy) convert to 12/08/2015 12:09:00 AM (date format is mm/dd/yyyy hh:mm:ss AM/PM)
When Sequence no 8 comes, 02/12/2018 (mm/dd/yyyy) convert to 12/02/2018 12:08:00 AM (date format is mm/dd/yyyy hh:mm:ss AM/PM)
When Sequence no 7 comes, 11/10/2018 (mm/dd/yyyy) convert to 10/11/2018 12:07:00 AM (date format is mm/dd/yyyy hh:mm:ss AM/PM)
When Sequence no 6 comes, 08/12/2015 (mm/dd/yyyy) convert to 12/08/2015 12:06:00 AM (date format is mm/dd/yyyy hh:mm:ss AM/PM)

This for Baked goods.

When Sequence no 9 comes, 07/25/2017 (mm/dd/yyyy) convert to 25/07/2015 12:09:00 AM (date format is mm/dd/yyyy hh:mm:ss AM/PM)
When Sequence no 8 comes, 07/25/2017 (mm/dd/yyyy) convert to 25/07/2015 12:08:00 AM (date format is mm/dd/yyyy hh:mm:ss AM/PM)
When Sequence no 7 comes, 07/25/2017 (mm/dd/yyyy) convert to 25/07/2015 12:07:00 AM (date format is mm/dd/yyyy hh:mm:ss AM/PM)



This for Dairy Products.

When Sequence no 9 comes, 07/24/2017 (mm/dd/yyyy) convert to 24/07/2015 12:09:00 AM (date format is mm/dd/yyyy hh:mm:ss AM/PM)
When Sequence no 8 comes, 07/22/2017 (mm/dd/yyyy) convert to 22/07/2015 12:08:00 AM (date format is mm/dd/yyyy hh:mm:ss AM/PM)
When Sequence no 7 comes, 07/21/2017 (mm/dd/yyyy) convert to 21/07/2015 12:07:00 AM (date format is mm/dd/yyyy hh:mm:ss AM/PM)
When Sequence no Blank comes, 07/19/2017 (mm/dd/yyyy) convert to 19/07/2015 12:00:00 AM (date format is mm/dd/yyyy hh:mm:ss AM/PM)
When Sequence no Blank comes, 07/19/2017 (mm/dd/yyyy) convert to 19/07/2015 12:00:00 AM (date format is mm/dd/yyyy hh:mm:ss AM/PM)
When Sequence no Blank comes, 07/16/2017 (mm/dd/yyyy) convert to 16/07/2015 12:00:00 AM (date format is mm/dd/yyyy hh:mm:ss AM/PM)

I hope my question will be clear now.

Thank you for your kind support.

[June7]

Try:

Format([EntryDate] & " 12:" & [Sequence] & ":00 AM", "mm/dd/yyyy hh:nn:ss AM/PM")