# End Date - Start Date Calculation **URL:** \ **Category:** Ask for Help\ **Created:** [December 7, 2021, 2:09am UTC](https://community.glideapps.com/t/end-date-start-date-calculation/35606 "2021-12-07T02:09:43Z")\ **Posts on this page:** 17\ **Page:** 2
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [December 7, 2021, 8:51am UTC](https://community.glideapps.com/t/end-date-start-date-calculation/35606/21 "2021-12-07T08:51:33Z")
what do you have in else option? did you leave it empty? ---
**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\ **Post date:** [December 7, 2021, 8:54am UTC](https://community.glideapps.com/t/end-date-start-date-calculation/35606/22 "2021-12-07T08:54:53Z")
yes, i make if the end date before today then choose end date if the end date after today then choose today. else empty. ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [December 7, 2021, 8:55am UTC](https://community.glideapps.com/t/end-date-start-date-calculation/35606/23 "2021-12-07T08:55:40Z")
that’s why is formating as text, put a date there meybe start date ---
**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\ **Post date:** [December 7, 2021, 9:06am UTC](https://community.glideapps.com/t/end-date-start-date-calculation/35606/24 "2021-12-07T09:06:19Z")
Still cannot ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/d/4da81cb9bb3dff94b10a93eb9838dd9edfdeea68.png) ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/2/8/28ae5b680699e1775b8a9077ce188281f0957fcf.png) ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [December 7, 2021, 9:08am UTC](https://community.glideapps.com/t/end-date-start-date-calculation/35606/25 "2021-12-07T09:08:40Z")
you are missing r in start ---
**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\ **Post date:** [December 7, 2021, 9:09am UTC](https://community.glideapps.com/t/end-date-start-date-calculation/35606/26 "2021-12-07T09:09:14Z")
what r ? ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [December 7, 2021, 9:10am UTC](https://community.glideapps.com/t/end-date-start-date-calculation/35606/27 "2021-12-07T09:10:45Z")
why is showing an invalid operation? ---
**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\ **Post date:** [December 7, 2021, 9:11am UTC](https://community.glideapps.com/t/end-date-start-date-calculation/35606/28 "2021-12-07T09:11:27Z")
That’s my main question… > [@biha](#): > > My problem is the the if-then column cannot be substract with Start Date as error “Invalid operation in date/time” ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [December 7, 2021, 9:14am UTC](https://community.glideapps.com/t/end-date-start-date-calculation/35606/30 "2021-12-07T09:14:06Z")
now date is a date? from the math column ---
**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\ **Post date:** [December 7, 2021, 9:15am UTC](https://community.glideapps.com/t/end-date-start-date-calculation/35606/31 "2021-12-07T09:15:20Z")
yes, correct. when it comes to if then column it cannot detect as date ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [December 7, 2021, 9:20am UTC](https://community.glideapps.com/t/end-date-start-date-calculation/35606/32 "2021-12-07T09:20:08Z")
you doing something wrong… it works for me… ![Screen Shot 2021-12-07 at 4.19.25 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/9/192ff3c62451b487390da7c1c27e3e24e5cdaf02.png) is probably the way you calculate “Now Date” in the math column, you have empty rows or some other than date format there, that’s why it can’t format to date ---
**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\ **Post date:** [December 7, 2021, 9:27am UTC](https://community.glideapps.com/t/end-date-start-date-calculation/35606/33 "2021-12-07T09:27:52Z")
is the results right ? ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [December 7, 2021, 9:28am UTC](https://community.glideapps.com/t/end-date-start-date-calculation/35606/34 "2021-12-07T09:28:45Z")
yes, all my apps work on durations > **[Time & Duration Picker DEMO](https://time-duration-demo.glideapp.io/dl/ewAiAHQAIgA6ADAALAAiAHMAIgA6ACIAYwBsAGEAcwBzAC0AVABpAG0AZQAgAFAAaQBjAGsAZQByACIALAAiAHIAIgA6ACIAUgBGAHAAWQBiAEkAcgBHAFEATAA2AEwAYwB6ADcAMABiADAAQQBzAHcAQQAiACwAIgBuACIAOgAiAEQAdQByAGEAdABpAG8AbgAgAFAAaQBjAGsAZQByACIAfQA=)** > > set only time in AM/PM or 24H format, or switch to duration > **[Personal Time Card DEMO](https://time-card-demo.glideapp.io/dl/ewAiAHQAIgA6ADAALAAiAHMAIgA6ACIAYwBsAGEAcwBzAC0AVABpAG0AZQAgAEMAYQByAGQAIgAsACIAcgAiADoAIgBIAHMAcAB1AEUAcwAzAEgAVABGAEcARQA1AG4ANwAyAHQAZQBKADYAWABRACIALAAiAG4AIgA6ACIAUABlAHIAcwBvAG4AYQBsACAAVABpAG0AZQAgAEMAYQByAGQAIgB9AA==)** > > Track your working hours, sort by week, month, or year. Export as PDF files ---
**Author:** ![biha](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/biha/32/84110_2.png) [@biha](https://community.glideapps.com/u/biha)\ **Post date:** [December 7, 2021, 9:30am UTC](https://community.glideapps.com/t/end-date-start-date-calculation/35606/35 "2021-12-07T09:30:52Z")
this is my now date both didnt work with +0 or without ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/7/a7736552ec7b6eb326d711bf46c8dcf1b9587d86.png) ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [December 7, 2021, 9:35am UTC](https://community.glideapps.com/t/end-date-start-date-calculation/35606/36 "2021-12-07T09:35:33Z")
![Screen Shot 2021-12-07 at 4.34.28 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/3/134bb630c45006f869819f33b168e849c0fd5c6e.png) ![Screen Shot 2021-12-07 at 4.35.01 AM](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/d/3/d39bc5f9feeade2002fbc1d66cbb48b88d54faf2.png) ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [December 7, 2021, 9:39am UTC](https://community.glideapps.com/t/end-date-start-date-calculation/35606/37 "2021-12-07T09:39:06Z")
you have something on the way that is not formated as DATE, sometimes is hard to find, maybe is coming from relations, or you manually enter or edit some of the dates? If is not too much work, I will redo all these columns ---
**Author:** ![Uzo](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/uzo/32/22639_2.png) [@Uzo](https://community.glideapps.com/u/Uzo)\ **Post date:** [December 7, 2021, 9:48am UTC](https://community.glideapps.com/t/end-date-start-date-calculation/35606/38 "2021-12-07T09:48:43Z")
refresh the editor and try to make a fresh sample, with a new columns formatted as a date, fill them up with a date picker… and if is still not working, then submit a ticket to glide… [Previous page](https://community.glideapps.com/t/end-date-start-date-calculation/35606.md?page=1)