Dates and Calendars

[#1]

I appreciate there are many, many discussions on here about this subject, but having spent half a day trawling through them I am still at a loss!

I have two calendar objects, which are linked to variables, and in the Min and Max Value I have entered =min({1} DATE(OCR_DATE_TIME_SENT_TO_OCR, 'DD/MM/YYYY')) and =MAX({1} DATE(OCR_DATE_TIME_SENT_TO_OCR, 'DD/MM/YYYY')) . the number format on both objects is DD/MM/YYYY.

I have formatted the field OCR_DATE_TIME_SENT_TO_OCR in the load script like this:Date(DATE_TIME_SENT_TO_OCR, 'DD/MM/YYYY') as OCR_DATE_TIME_SENT_TO_OCR - this works as when I use this field in a table or simply add it to the sheet, it appears in this format without any need to amend the number forma

have set the Date format as

SET DateFormat='DD/MM/YYYY';

But when I pick from my calendars, nothing is selected. And in the variable overview, the definition of my variables is in this format:

42775.753472222

So I can see that the date formats are not the same, but I cannot see why the variable is still being populated with numbers. I even tried removing formatting from everything, and it still wouldn't select anything!

All help appreciated

Ella

[adamdavi3s]

Ahhh ok, hmmm this isn't quite so easy I am afraid!

Sorry just for my own clarification (not had much sleep)

You want users to be able to enter a start date then an end date and for this to then make selections in the calendar?

This is possible but I would advise a button to do it....

[#3]

I do need users to be able to enter a start and end date - we use calendars in other applications without issues, I did toy with a button, but the users are used to calendars (and you know users... change is not a good thing )

[adamdavi3s · Accepted solution]

The attached uses a button, but I have also added a variable trigger for you.

Just try changing the end date variable and watch the magic work

Sorry I am crazy busy so I have only added it on the venddate variable but you can just add the same on the vstartdate variable.

Settings> Document properties > triggers then look at the variable triggers section.

You need both on input and on change to make sure it always works.

[#5]

the trigger was missing!! thank you for your help and time