*** i moved to my own blog site so to check on my future posts, please go to www.junblogs.com  ***

i made the other day the sscal class and i thought to myself, who or what is keeping me from creating a datetime picker?  and the answer is no one and nothing.  and so you are seeing now the newly created ssdtpicker class.

brief introduction to some features:

1.  well of course, first and foremost would be, it is 100% native vfp.

2.  it comes with a variety of 5 colors again.  on normal stage (when calendar is not visible), the current color will be reflected by the button in the right side.

to hide it back, click again the button.  that button toggles between showing and hiding the popup calendar.

3. unlike the activex dtpicker’s popup which cannot stay open when you click on another object, this one can

4. it auto-adjusts itself (and auto-resizes as well)  to follow whatever the current set date setting is:

5.  working with the class value is as simple as these:

x = thisform.ssdtpicker1._value
insert into mytable (flddate) values (thisform.ssdtpicker1._value)
replace flddate with thisform.ssdtpicker2._value in mytable

declaring the initial values is easier, in the init event of that class’ instance in a form:

this._value = date()
this._color = “blue”

6.  in the tradition of a dtpicker, clicking “today” will bring you back to the current date.  the calendar will likewise be repainted back to current date.

7.  like any other dtpicker, you can manually encode the date on the date box.

8.  no graphics used whatsoever which lessens additional weight to a project.  the whole class is composed of labels, containers, etc.  but not a single image is used.

9.  and since it is 100% vfp, it will not introduce problems to your project which sometimes an activex do.

shift of style:

some people are maybe wondering why i suddenly changed attitude from simply attaching whatever it is i am trying to share into doing it on a request basis which means more further work on my side.  but lately i felt some of my contributions are not that appreciated, i don’t know exactly why that feeling and what has fired it.  but it happened. i actually thought before of stopping contributing further but the feeling has subsided.

i believe i am not alone in that appreciation thing so i will be so bold in saying i will be speaking in behalf of some if not most of the contributors of weblogs.  we need feedback of how things work out on your ends.

so to avoid having that ugly feeling again, in my end, i decided to “know” who is really interested in any of my new ideas (except when it is pure tutorial).  and being the author of whatever it is i am sharing or will share more in the future, i am entitled to this decision.

i think you can see from the above what this class can do to enhance your project.  if you like it, all you need to do is request; if you don’t like or don’t feel like requesting for the class from me, then it is you loss not mine!

however if you can wait for me to change mind again in the future, then you can simply wait for that to happen.  who knows?  out of a whim, i may suddenly place the attachment here again one time?


update december 8, 2009:

the old one can not cater versions lower than 9, this one does.  there are some more changes inside:

a.  removed declaration of zorder(1) in the init which brings the class in the back of other objects (a bug).  only the zorder declaration in toggling visibility of popup calendar is needed, thus, retained.

b.  added the ability to show or not show "today" section.  depending on the taste of the user, sometimes without the today section looks better.  by default it is shown, to remove it add this in the init event of the class' instance in a form:

this._notoday = .t.

c.  enlarges a little bit the days and weekdays objects to make things more readable.  adjusted the popup calendar size as well.

d.  added a shape in replacement of the commandgroup for month navigation which will err in versions lower than 9 as it uses command button's backcolor property which do not exists yet in the older versions.  so when you are running below 9, shape object will take control of showing the colors of the calendars plus toggling its visibility on and off.

e.  for versions lower than 7, i remove the themes capability. 

there are some more minor adjustments as i am trying to make this run on versions lower than 9 as well like the specialeffect properties.  i created this class in 9 and i really don't know if somebody will take an interest in this one before so i never minded preparing this for other versions.  now i believe i have done that. 

so to those who already have this who might experience some problems with this class, please inform me via email so i can attend to it.   to those who still only have the first version, i will update you via email later today.  you have my email address now so if something needs bringing into my attention, please bring it to me.  cheers!

update: december 26, 2009

i already have submitted the classes for free and easy download to eric
for the download section of foxite, so you will see those pending the
decision of eric.  in addition, i have created a thread in coderisland
to have the same available for download.  please click on the link


36 Responses to SandStorm s Date Time Picker

  • Chaim says:

    Hi Jun,

    Your products is amazing.

    Why didn’t you sent it to Bill Gates before the decision to stop with foxpro?:)

    Can you please send me a copy (also for the previous cools).

    I give here another email:tsvikivolkan at gmail dot com.

    Thank you

    #  Hello Chaim, Thanks for the nice words.  I am just working on a lot of things I can think of these days as I am still on vacation.  Very soon I will have to go back doing what is really expected of me, my real job (I.T.), and eventually I have to slowdown on contributing here.

    All three latest classes is sent to your email, i.e., Switchbox, SSCal and SSDTPicker. 


  • Spion says:

    Hi,its cool!

    would u send it to me. my email

    spions09 at yahoo dot com

    # Thanks!  Sent to your email

  • Vladimir Martinovski says:

    I like to test it also. Look great like this.

    vladimirm at fx dot com dot mk

    #Well please do.  Please come back to me when you have problem.  Sent to your email.  Cheers!

  • Dan says:

    Hi Jun, You know its awesome how you develop tools to tame everyday’s hitches, when i had a problem with a datepicker in a grid, you gave me the “How to tame a datepicker in a grid animal” Now i cant wait to try this new class. Please do send it to me. My email is: sleek at yahoo dot com.

    Thanks alot

    #Thanks for the compliment Dan.  I just do what I can.  Please find in your email the dtpicker class. Get back to me when you have a problem with this one.  Cheers!

  • Victor Espinoza says:

    Hi Jun,

    Your classes look very nice. I would also like to test them. Please send them to victoresp at hotmail dot com.


    #Thanks! Sent to your email.

  • Nestor Buelva Jr. says:

    Very nice class. I will love it. I used to use ActiveX DatePicker class. This will save me a lot of maintaining and distributing headache when using ActiveX controls.

    Please send me the class to nestorj2000 at yahoo dot com.

    #Thanks.  Your email is rejecting my mail.  Please check the email address you have provided above.  Or provide me with another one

  • Sanjay Karia says:

    Hi Jun,

    I also want to use your class. Can you send updated classes of Switchbox, SSCal and SSDTPicker on my email address it is

    kariasanjay at rediffmail dot com


    #Sent to your email.  Cheers!

  • Tanveer ul hassan says:

    its very nice and cool. can you send me with thanks.

    mthassan2000 at yahoo dot com

    #Thanks!  Sent to your email.

  • Byron Santizo says:

    I also want to use your class. Can you send updated classes of Switchbox, SSCal and SSDTPicker on my email address it is

    ByronSantizo at hotmail dot com


  • Joey Carroll says:

    Hi, please send these fantastic classes to me at joeydcarroll at gmail dot com

    Keep up the good work!


  • alwy ali says:

    Hi Jun

    this is a cool thing it going to make life more managable. Can you please send to me via my email

    alialwy at hotmail dot com

    Thanks In Advance



  • Miguel says:

    Good work! Please send a copy to mlopez dot bo at gmail dot com  Thanks for sharing.

    # Welcome.  Sent

  • Nestor Buelva Jr. says:

    Sorry, I forgot one character.

    The right email is nestorbj at yahoo dot com

    Thanks again.

    #Sent to your email

  • Nestor Buelva Jr. says:

    Thanks for the SSDtpicker class you sent. It’s wonderful. Can you sent me the Switchbox, SSCal class also?

    nestorbj at yahoo dot com


  • Imran Syed says:

    Amazing Work Jun

    as usual you bring unique ideas in VFP

    great work, can i have a copy to try and implement it in my application with your kind permission.



    ihsyed at yahoo dot com

    # Of course, sent to your email.  Cheers!

  • Marian says:

    Hi Jun,

    it`s perfect work!

    pls, send me  Switchbox, SSCal and SSDTPicker to

    infos at infos dot sk

    Thx. Marian.

    #All three classes sent to your email

  • Marian says:

    Hi Jun!

    Its perfect work!

    Pls, can you send updated classes of Switchbox, SSCal and SSDTPicker on my email? Thanks. Marian.

    # Please check your email, sent

  • Petr Zugar says:

    Very nice class. Please, send me your class Switchbox, SSCal and SSDTPicker on my email.

    zugar at jvk dot cz


    #All three classes sent to your email

  • ken knorr says:

    Cool, would you send this also.

    kknorr at logoscms dot com

    # Sent as well in your email.

  • Jarda says:

    Great work, please send me a copy

    #Sent to your email

  • sandstorm36 says:

    December 10, 2009

    Please do not use the URL section in posting your email addresses.  I am finding it hard to get the proper email that way.  Also sometimes, I simply forgot to check it.

    Further, I will suggest now that you put here your proper email address without resorting to “at” and “dot”.  I remembered that I need to approve any comments so I can change it before showing it here later.  

    That is the reason why sometimes you cannot see immediately your comments/requests.  I have seen and deleted some double request in that maybe the requestee thinks her/his comment/request has not gone through.  It does.  However it still needs to be approved by the author of the blog to determine whether it is a spam or a real one.

    To those who have found problems, please inform me.  So far everybody seems to be satisfied.  So once again, Enjoy!



    PS.  I just realized today that sometimes I inadvertently replied to weblogs instead of the requestee themselves.  In which case, if you haven’t received a class from me, don’t hesitate to inform me on my email.  My  apologies

  • N. K. Patel says:

    That’s great !!

    I am interested in your great work.

    Please send me those classes at

    nareshdhakecha at gmail dot Com

    #Thanks!  Sent to your email!

  • RMCollection says:


    great job!

    Can you please send your class.

    info at wawi3 dot de

    #  Thanks!  Sent

  • the class is very nice, i would like to have it


    # Sent!  Please do not use the URL section of the comment next time for your email.  I am finding it hard extracting the email address there.

  • drserhio says:

    Nice work!

    Please send me your classes.  

    drserhio at gmail dot Com

    #Sent to your email, thanks!

  • Cesar says:

    Hi Jun,

    You said in this post:

    >>… “to avoid having that ugly feeling again, in my end, I decided to “know” who is really interested in any of my new ideas …”

    Please don’t do that !!!

    Look, it took me about almost a week till I decided to ask you directly to send me the ssCalendar class from a previous post. Just because I did not want to publish my email in a blog comment. When you take that attitude, believe me, you are limiting the quantity of people that will appreciate your work.

    ANother thing is that people do always recommend some links, and doing that people will share those files directly.

    I suggest that you can upload your files to a separate server, that will allow you to have a downloads counter.

    Please understand that these files need to be very easy to be accessed, and tested. You have great ideas, and a very nice eye for design.

    FYI: I’ve adapted the ssCal class and it’s already in my app.

    It’s really fantastic to have feedback, but sometimes it does not happen, for many reasons, and believe me, zero feedback does not mean that people did not apreciate your work. Suddenly you’ll find references to some posts of your on the web !!!

    #Thanks Cesar for the kind words and trust.  Please read my Why? blog.

  • Dawn says:

    Great Work Jun

    send me your class Switchbox, SSCal and SSDTPicker on my email.

    dawn dot evalone at hotmail dot com

    #Sent to your email.

  • Chandu says:

    Hi Jun,

    Your classes look very nice. Please send them to ctrktr at gmail dot com

    # Sent to your email

  • Naeem says:


    Great work. Please send me your classes to just123go at hotmail dot com


    # Please check your email.  Cheers!

  • boudewijn lutgerink says:

    Hi Jun,

    next time you develop such a nice class attach the code to the message, you then save yourself a lot of time.

    Now I line up with the others, please send it to B dot Lutgerink at betuwe dot net, I am in absolute need for this for one of my apps.

    #LOL!  I am going to make it downloadable but that would be next year BL!  For now, please be patient with my little experiment.  I will send all three classes to you so in case you also think later of wanting the other 2, you need not request anymore. 

    And I am not exaggerating when I say to all of you that you will love more the upcoming next 2 classes!  One will be my pre-Christmas gift to “interested” people and the other as pre-New Year gift.  Cheers!

  • Hernan says:

    Great work and is nice to see that people still create helpful classes in VFP.

    Please send me the files to hedg at prodigy dot net dot mx

    #Well, VFP is really a very powerful tool and very easy to use.  As long as we can come up with new tricks, I believe it will last long.  Sent!

  • curie says:

    so cute!!!

    please send me a copy.. please please..

    (gudgadglenda at yahoo dot com)

    nice work!!!

    thanks a lot..

    #Well I am thinking of the song “to all the girls I loved before!” when I made those (kidding). Big Smile <img src=” />

    I am glad you like it, please check your email.  Sent

  • Zdenek Karas says:

    Hi Jun,

    Your classes look very nice. I would also like to test them. Please send them to karas at zliv dot net.


  • Son, Nguyen Hong says:

    Your class so cool!

    Thanks for your unlimited creation with VFP.

    Please send me a copy to daisygroup at gmail dot com.

    Many thanks !

  • rommel says:

    Great work kababayan! This will truly improve the look of our applications.

    Please send me those classes at

    rommel dot david at ever dot ph

    #Hello Rommel.  Thanks for the nice words.  Please read the last message above of this blog (not the comments) as I already gave the links where it as well as the other 4 classes can be downloaded.

  • simon says:


    That is great stuff!!! Kindly send me to my email: kimanicom@gmail.com

Leave a Reply

Your email address will not be published. Required fields are marked *