The end_date is the end of the period you wish to calculate as a fraction of a year. The [basis] lets us define the âyearâ in a few different ways. 1 will give us the actual year. The DATE function takes a numerical year, a numerical month between 1-12, and a day between 1-31.
A. There are general guidelines for each literary category: Short stories range anywhere from 1,500 to 30,000 words; Novellas run from 30,000 to 50,000; Novels range from 55,000 to 300,000 words, but I wouldnât recommend aiming for the high end, as books the length of War & Peace arenât exactly the easiest to sell.
Below is a guide to story lengths and how they might be named (thereâs a fair bit of overlap as research shows that opinions differ greatly): 1  Flash fiction: under 1,000 words. 2  Short story: 500 to 17,000 words. 3  Novelette: 7,500 to 25,000 words. 4  Novella: 10,000 to 70,000 words. 5  Novel: 50,000 words or more.