Date control

Question

Hi I wanna control a date value from a cell (in an excel file) and is this date between 2 of them or not? I mean there are 3 cells and all of them's format a date value. I want to know the first value is between of the another 2 cell's value? I've never been work with date values so i dont know so much. How can i do that?

Jure · 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);

yokzu · Answer

Thanks a lot Jure.

yokzu · Answer

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?

Jure · Answer

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 } If you need inclusive checking replace   with  =. How are dates written in cells (i.e. dd/mm/yyyy or mm-dd-yy etc)?