Good day everyone
Usually I use Master Calendar to generate my date related fields like Quarter, Month and so on
I wanted to use a field that contains date as well as time (Please see attached file "Date,png")
I have issues when I use this field
Please find the attached files including the master calendar script I used.
How can I resolve it?
What is the granularity you are expecting a day, an hour since you included time as well now.
If no change in granularity and u want calendar at day level, you may think of having two date fields, one with time and another without time, second one you can use for your calendar and first one for other use you may have thought of.
Also please share sample data in case its possible.
No idea, bur your variables vMinDate and vMaxDate don't have values. Check that your Temp table contains records after creating it.
gwassenaar Thanks for your response
My temp table is ok. If I choose any other date field without time value, It will give me a good response but I want to use the change log date to generate those fields (quarter and so on)
Please find attached file for clarity
As gysbert suggested your variable don't have any value and that what your attached image also told.
In Date2.png You see empty value for varMinDate and varMaxDate
similarly in Date3.png, error is Monthstart() required value and because of that you will get error.
check what value you get in varMinDate and varMaxDate.
Your timestamp fields do not contain valid timestamps, but text values. You need to use the TimeStamp# function to turn the text values into real timestamps.
gwassenaar Thank you for spotting that out.
Can u assist me on how I can use that timeStamp# function?
Can you use the data I attached earlier to make a demo on qvw for me?
I appreciate your response sir
dreamer4 Thank you for your response,
It's when I use the Change Doc at last ... I get this error..
If I use QA IMPTD DATE and other similar fields, I have no errors.
Check it out