Date control

Jure16y ago

Accepted answer

I think it's best to use DateTime class, because it handles everything for you. With your formatting you can just do this:

string cell_example = "21.10.2010 01:48:00";
DateTime date = DateTime.Parse(cell_example);

yokzu16y ago

Thanks a lot Jure.

yokzu16y ago

Sorry i forgot the format of cell's.
21.10.2010 01:48:00

How can i transfer this cell's value to a variable? Should i use a datetime variable?

Jure16y ago

I'm not sure what exactly are you asking for, but to check if date is between two other dates, you can use this:

        bool IsBetween2Dates(DateTime date, DateTime start, DateTime end)
        {
            return date > start && date < end;
        }

If you need inclusive checking, replace "< "and ">" with "<=" and ">=".

How are dates written in cells (i.e. "dd/mm/yyyy" or "mm-dd-yy", etc)?