Master Calendar Challenges

[akpofureenughwu]

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?

[akpofureenughwu]

gwassenaar‌

Thanks but can u send me a pdf/video to learn this function

I will be grateful if you use the attached file to do a timestamp# function demo for me.

Thank you

[PrashantSangle]

see Gysbert reply every function related date and time are available in help menu or press F1 and type function whichever you want search.

check it try it if still issue then we are there to help you.

Regards,

[Gysbert_Wassenaar]

If you're not even willing to look up a function in a help file then you're beyond help as far as I'm concerned. Try finding a job that is less demanding for you.

[akpofureenughwu]

gwassenaar‌

That's kinda harsh.... I am currently reading on timestamp and look at previous posts on it.

I am committed to what I do that why I asked for help...

Please let's be patient with one another

When I done with my research, If I got any challenge, I will let you know.

Best Regards

[akpofureenughwu]

I'm on it.. Thank you

[akpofureenughwu]

gwassenaar‌ Hello sir, Still no luck yet..

Can you help me with Clues?

I'm running out of time.

Best Regards

[akpofureenughwu]

Hello sir, I got it

Using the script

Date(Floor(Timestamp#("CH#DOC#LAST CHANGED AT", 'DD.MM.YYYY hh:mm:ss')), 'MM/DD/YYYY') as Date,

I was able to manipulate the date from the timestamp, but I didn't use the master calendar techniques, I use the preceding load for the date variables.

I still need more pro tips on this subject...

[PrashantSangle]

Awesome man,

try little bit more. Read some more threads. You are almost close to your answer.

Regards,

[akpofureenughwu]

I got a unique challenge right now

I was putting my data from SQL, I got the desired date field results (Month, Quarter and so on)

But for this work, I need to put the data from excel sheet... (Same structure, same field with the SQL connection) but the date fields are missing.

Please see attached files for clarity!!

I can you help me with clues how I will debug it

Thank you

[PrashantSangle]

Hi,

Just make sure your [CH.DOC.LAST CHANGED AT] is in date format not in text.

try with date#() or timestamp#()

try like

Date(Floor(Timestamp#([CH.DOC.LAST CHANGED AT], 'DD.MM.YYYY hh.mm.ss')), 'MM/DD/YYYY') as Date,

Regards,